Chapter 8. Working with Change Data Capture in SSIS 2012
Change data capture (CDC) and using the change data has become a common and important operation in most data warehousing scenarios. Integrating the process of creating and consuming change data in extract-transform-load (ETL) processes is a common requirement. SSIS and SQL Server enable you to easily create and consume such change data. This chapter introduces various CDC techniques in SQL Server and how you can use SSIS to consume the change data. It also introduces you to the new CDC components for Oracle database systems.
CDC in SQL Server
CDC is the process of capturing change data in your tables. The types of changes ...