Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Nov 26, 2010
The fourth of a six-part series demonstrating several techniques for loading dimensions using SQL Server Integration Services. This video demonstrates how to design a data flow using the standard SSIS components (other than the SCD Wizard) to detect source system changes, and update dimension rows appropriately. The following videos demonstrate how to load dimension tables using the T-SQL MERGE command and the Kimball Method SCD component.