Dimension Merge SCD Transform
The Dimension Merge SCD is a powerful replacement for the native Slowly Changing Dimension (SCD) wizard in SSIS.
SolarWinds 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.
Learn More About Task Factory Pricing
Task Factory
Task Factory Azure Data Factory
Dimension Merge SCD Transform
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.
Feature Highlights
- Load a dimension up to 700x faster in SSIS since it's not a row-by-row operation
- Handles Type 0, 1 and 2 dimension column types
- Detailed audit trails and performance logs
- Scales to dimensions with billions of rows
Task Factory Licensing Options
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.
Task Factory
Annual Subscription License
$1,245
65+ SSIS tasks and components
