Main Content

Dimension Processing with SSIS - Simple to Complex

About the Talk

May 22, 2010 5:00 AM

University of Portland, Oregon

University of Portland, Oregon

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.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus