Database Target Reset
Reset a relational target table in a Data Replication task to drop all of the target tables in the task.
You might need to reset a relational target for the following reasons:
- •If the data type, precision, or scale of a Salesforce source field changed and you run the Data Replication task as an incremental load, the task might fail. This is because of a mismatch between the data types of the source field and the column of the relational target table. The task might also fail because the target table column might not be able to store all values from the Salesforce field. You can reset the target table to synchronize the data type, precision, or scale of the target table column with the Salesforce field. If the precision or scale decreases, the Data Replication task succeeds and the target table columns remain unchanged.
- •You delete a field in a Salesforce source and the Data Replication task writes to a Microsoft SQL Server relational target.
If you run a Data Replication task that writes to a Microsoft SQL Server target and the source is missing a field or column, the Data Replication task fails. To run the Data Replication task successfully, reset the target table to re-create the target based on the latest source definition, and then run the Data Replication task.