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.
Hi, thanks for the videos, very helpful.
robertosaile 1 year ago