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.
A Task Factory license is not required to use Task Factory when developing and running packages in Visual Studio/SSDT. However, a Task Factory license is required to use Task Factory for packages run outside of Visual Studio/SSDT.