O'Reilly logo

Microsoft® SQL Server® 2012 Integration Services by Rakesh Parida Wee-Hyong Tok Matt Masson, Xiaoning Ding, and Kaarthik Sivashanmugam

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required