Synchronizing Transformations to Target Destination
Transformations can be synchronized on demand or via the scheduler. This section describes how to synchronize a table on demand. For information on scheduling tables for synchronization, please refer to Designing a Schedule.
To execute an on demand synchronization task for a table:
1. Select the Transformations tab.
2. Select a transformation or transformations, and click the Sync button.
3. Select the synchronization method that you want.
The recommended synchronization for the select database is displayed. An Incremental Update is only available if a full reload has already been performed. Automatic will perform an Incremental Update unless the amount of changed records has exceeded the Full Reload Threshold, or a unique key is not available for the table.
If Incremental Only has been selected, it will always incrementally update the table (the full reload threshold will be ignored).
CRC SavePoint and CRC Baseline are not used with Table Synchronizations. For more information on the CRC types, see the section on Creating and Syncing Change Data Capture Transforms.
4. Click the OK button to start the synchronization process.
When the synchronization process starts, the application will switch to the Overview Summary Page and will display the current status and progress of all running synchronization jobs.