Checkpoints and Restarts
Checkpoint and restart operations are not supported for export jobs (unloading data); however, checkpoints and restarts are supported for load jobs (loading data). Restarts for load operations are only supported when the following conditions are met:
Check the source data to make sure it has not changed between the initial load attempt and the restart. The Teradata OLE DB Access Module does not check for changed data during the restart operation. If the data has changed, the loaded data may not reflect the true contents of the source table.
The following can occur during checkpoint/restart operations:
For bulk load operations, the number of rows displayed in the progress dialog box might not be the same as the number of rows returned to the utility if a restart occurs. In this case, the progress dialog box might display a larger number of row retrievals than the number of rows actually retrieved from the data source.