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. |
Enable Target Bulk Load | Uses Microsoft SQL Server bulk API. When you replicate data from Salesforce to Microsoft SQL Server in bulk mode, the task fails. This issue occurs if you change the datatype, precision, or scale of a Salesforce field and re-run the task. |
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. |