MySQL Connector Guide > Data Replication Tasks with MySQL > Data Replication Target Properties
  

Data Replication Target Properties

When you replicate data to a database target, the Data Replication task truncates the table name in the target database when 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 the Informatica Cloud User Guide.
Load Type
Determines all new, changed, and deleted data in the source objects since the last run, and propagates the changes to the target objects.
Delete Options
Removes or retains deleted columns and rows.
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.