CHAPTER 12
Change Tracking and Change Data Capture
This chapter focuses on two core techniques that allow you to detect modifications to source data and consequently update a destination table with the corresponding changes. Using their most simplistic definitions, these techniques are
- Change Tracking : Detects that a row has changed. Lets a process return the latest version of the data from the source table.
- Change Data Capture : Detects that a row has changed. Stores all the intermediate changes, as well as the final state of a record.
The former uses a tracking table and simple versioning, while the latter reads the SQL Server transaction ...
Get SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.