Primary Navigation

Site Search

Main Content

Data Warehouse Dimension Processing with SSIS

About the Talk

June 12, 2010 10:00 AM

THE MIXER, 15255 NE 40th Street, North Commons, REDMOND, WA 98052

THE MIXER, 15255 NE 40th Street, North Commons, REDMOND, WA 98052

The SCD Wizard included in Integration Services is easy to use, and has all the features you need for smaller, simple dimension processing. However, it is not the easiest component to adjust, and doesn't perform very well with larger dimensions. This session will cover three alternative techniques for processing changes to dimension tables within SSIS: "rolling your own SCD" with Lookups and Conditional Splits, using the T-SQL MERGE statement, and the Kimball Method SCD component. The strengths and weaknesses of each technique will be described and demonstrated.