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 ...

Get Microsoft® SQL Server® 2012 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.