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 want to drop a target table to re-create it based on the latest source object definition. When you reset target tables for a Data Replication task, the task completes the following steps:
- 1. Drops all of the target tables included in the Data Replication task from the database.
- 2. Sets the load type for the Data Replication task to full load. You must run a full load to reload the data from all source objects included in the Data Replication task.
When you run the Data Replication task after you reset the target, the Data Replication task recreates each target table. The Data Replication task then loads all of the data into the new table.
You might need to reset a relational target for the following reasons:
- •You delete a field in a Salesforce source or a column in a database target 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
- •The relational target table is damaged. If the target table is damaged, the Data Replication task might consistently fail to write to the target table.