You can resynchronize source and target objects for a subtask that is part of a running
database ingestion
combined initial and incremental load job. The subtask must be in a state other than Queued or Starting.
For example, you might want to resynchronize the target with the source if initial load or incremental load processing failed or if you want to start the job over again from a specific restart point.
To resynchronize tables that stopped and are currently in the
, drill down on an ingestion job to display job details.
The job must be in the
Up and Running
state and be for a combined initial and incremental load operation.
Click the
Object Detail
tab.
In the subtask row for the source and target objects that you want to resynchronize, click the Actions menu and select
Resync
.
For the Actions menu and
Resync
option to be available, the subtask must be in a state other than Queued or Starting.
If the source table schema does not match the target table schema, the ingestion subtask drops the target table and creates a new table that matches the source schema. Regardless of whether the target tables are re-created, the subtask truncates the target tables and then reloads source data to the tables.
If the source table contains many rows, the resynchronization might take a long time to perform.