Details

Handling Advanced Data Warehouse Scenarios in SSIS

John Welch
60 minutes
Level 500
Beginner
So you’ve used SSIS to populate a simple star schema data mart, and everybody’s happy. But now you have new requirements that require more advanced data warehouse approaches, like late arriving dimensions, bridge tables, parent child dimensions, and Type 3 or Type 6 slowly changing dimensions (SCD). How do you handle those in a scalable, efficient way in SSIS? This session will present some common patterns for handling these scenarios. You’ll learn when to use each advanced approach and the pros and cons associated with each pattern. You will learn how to implement these patterns in SSIS, and how to tune them for high performance.

Accompanying Material

No material found.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids