Data Replication Target Properties
When you replicate data to a database target, the Data Replication task truncates the table name in the target database if the source object name exceeds 128 characters.
The following table describes the target properties in a Data Replication task:
Property | Description |
|---|
Connection | Name of the target connection. Select a target connection or create a connection. |
Target Prefix | String that prefixes the source object names to create names for the target objects in the target. Note: For more information, see “Truncating Table Names” in Deploy. |
Load Type | Replicates full load of data from MySQL to other applications. |
Delete Options | This property is not applicable for MySQL Connector. |
You can also configure the commit size, which defines the number of rows to commit. If you do not specify a value, the Secure Agent uses the default value. Default is 10000.