This talk will discuss the advantages of an incremental approach to data loading in the data warehouse environment, and review the options provided by SQL Server 2012 for implementing this pattern. We'll take a closer look at SQL Server Change Data Capture from the database engine perspective, then look at how the new Change Data Capture components in SQL Server 2012 Integration Services make it easier to incorporate this technology into your ETL processes.
SQL Server Professional with fifteen years of experience of Microsoft SQL Server development and administration across all versions from SQL Server 6.5 to SQL Server 2012, currently working on Data warehouse and Business Intelligence projects using Microsoft technologies.