The Dimension Merge SCD is a powerful replacement for the native Slowly Changing Dimension (SCD) wizard in SSIS.
Task Factory provides dozens of high-performance SSIS components, including the Dimension Merge SCD transform, that save you time and money by accelerating ETL processes and eliminating many tedious SSIS programming tasks.
Dimension Merge SCD is a powerful replacement for the native slowly changing dimension (
The transform uses the Kimball methodology to load a slowly changing dimension in SSIS much faster than the built-in components for SSIS. Traditionally in SSIS, this is a row-by-row operation! The transform also gives you fine-grain customizability as a developer, letting you solve nearly any business problem.