Change Data Capture
An important concern, when dealing with data integration, is to detect which data has changed since the last time we accessed the source data location. It's required to avoid affecting source system operations and to make the process of reading data from a source location faster. It's better to get just the changed data, than extracting all the data.
Change Data Capture (CDC) feature was included in SQL 2008 version. It provides the possibility to detect change in data in a database. CDC seems to be one of the most powerful approaches as compared to the other known approaches such as audit columns, timed extracts, database log scraping, check sums, and others, CDC has low impact (does not require any changes into the main tables), low overhead (runs asynchronously, unlike the triggers used in the audit columns approach (the most often used approach)), is also easy to use.
In spite of using the Datetime
field to get the data change ranges, CDC uses a unique and sequence...