|Title:||Datawarehouse Dimension Processing with Integration Services - From Simple to Complex - Todd McDermid
|Start:||4/19/2012 12:00:00 PM
|End:||4/19/2012 1:00:00 PM
Data Warehouse Dimension Processing with Integration Services - From Simple to Complex
Overview: 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.
Takeaways: SSIS is capable of processing large dimensions by using techniques other than using the included SCD Wizard..
Todd McDermid is a SQL Server MVP, and is heavily involved with the Integration Services community. Speaking, blogging, leading open-source extensions, and moderating MSDN threaten to take time away from providing BI solutions at Moulding and Millwork. I've earned an MVP for blogging, speaking, moderating the MSDN SSIS forum, and publishing multiple code samples and extensions for SSIS on CodePlex.
Contact URL: http://toddmcdermid.blogspot.com