The fifth of a six-part series demonstrating several techniques for loading dimensions using SQL Server Integration Services. This video demonstrates how to set up an SSIS package to use the T-SQL MERGE command to detect source system changes and update dimension rows appropriately. The next video demonstrates how to load dimension tables using the Kimball Method SCD component.
Link to this comment:
All Comments (0)