Details

CDC + SSIS = SCD

Speaker: Patrick LeBlanc

Duration: 60 minutes

Track: Room 2172 - DBA

Building dimensions using the Slowly changing dimension wizard in SSIS is simple and quick. However its performance and flexibility is questionable. Even further, when trying to perform incremental loads of your Dimensions using the aforementioned approach or a custom approach prior to Change Data Captured (CDC) offered certain challenges. In this session Patrick will show you how to utilize CDC and SSIS to incrementally load Type I and Type II dimensions using features that are all native to SQL Server 2008.

Accompanying Material

No material found.


Back to Top