Business Intelligence #04b: Implementing Slowly Changing Dimensions in the Data Flow

Posted By: Zach Skyles Owens | Dec 13th, 2007 @ 1:17 PM | 6,844 Views | 2 Comments

This screencast covers one of the most common scenarios when building a data warehouse.  It introduces the concept of Slowly Changing Dimensions (SCD) and how to solve that challenge with SQL Server Integration Services (SSIS).

This screencast is the first in a series BI Developer screencasts recorded as part of a workshop built on SQL Server 2005 that have been delivered around the globe by Microsoft and Microsoft Partners.  This training event takes the student through the Microsoft BI Platform giving a BI Developer the introduction and basic comfort needed to tackle a BI project using Microsoft technology.

If you missed the first screencast in this series I highly recommend that you watch it first as it provides a great overview of Microsoft BI technology.  Additional screencasts will be published under the "SQL+Server" so subscribe to it now!
Media Downloads:
Rating:
0
0
#Dec 14th, 2007 @ 11:31 AM
ZachSkylesOwens
ZachSkylesOwens

We are really interested in your feedback on Implementing Slowly Changing Dimensions in the Data Flow.

What would you like to see done differently?

What do you think worked well?

Feel free to leave a comment here or reply privately.

#Nov 13th, 2008 @ 5:08 AM
ZachSkylesOwens
ZachSkylesOwens

There is apparently an issue with the way these videos are encoded and Silverlight player...  You can watch these videos by clicking on the "Downloads" link then selecting "WMV".  I'll see what I can do to get this fixed.  Sorry for the inconvenience.    

Microsoft Communities