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!