Initial target load and refresh - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last edition
2024-09-05
Last publish date
2024-09-05T15:00:09.754973

The initial load of the target datastores and the methods employed to achieve full synchronization of the source and target are an easily overlooked but important and significant activity. The same methods can be used as needed to refresh all or a subset of the normal CDC/Apply targets.

In the case of Keyed Files, the Keyed File Compare Capture itself can easily be configured to compare the "current" version of the file against an empty file. The resulting differences resulting in an Insert for every record in the current file.