The last of a six-part series demonstrating several techniques for loading dimensions using SQL Server Integration Services. This video demonstrates how to use the Kimball Method SCD component to detect source system changes and update dimension rows appropriately. Previous videos show the equivalent actions using the SCD Wizard, other SSIS components, and the T-SQL MERGE command.
How this setting/process of SCD can handle the two different changes made within one day (last day)?
MrKalach666 7 months ago