Task Factory Feature: Dimension Merge SCD Transform 

Dimension Merge SCD Transform

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.

Download Free Trial

Learn More About Task Factory Pricing

Task Factory Modules

Choose from 13 Task Factory modules that address specific SSIS tasks and data sources. Learn More

 

Task Factory

Includes 70+ high-performing SSIS components that help you efficiently manage ETL pipelines. Learn More
 

Task Factory Azure Data Factory 

Includes 65+ high-performing SSIS components that help you efficiently manage ETL pipelines in Azure Data Factory (ADF). Learn More
 

Dimension Merge SCD Transform

 

Task Factory Dimension Merge SCD Transform

Dimension Merge SCD is a powerful replacement for the native slowly changing dimension (SCD) wizard in SSIS. This component includes a much more in depth interface than the standard SCD wizard and does not need the OLE DB Command transform. The component loads the data in memory for a much faster response and scalability. Experience a dimension load of up to 700 times faster than native SSIS SCD components.

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

 

"At the University of Calgary, I can say with confidence that halfway into the conversion effort, using Task Factory has been one of our smartest and most cost-effective software acquisitions in recent memory."

—Gabriel Gray, University of Calgary

 

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.

Compare Editions

Task Factory Modules

Annual Subscription License

 

$425–$795

Per Server


Learn More

Choose from more than a dozen Task Factory modules, each of which delivers high-performance components targeted to a specific SSIS task.

Task Factory

Annual Subscription License

 

$1,245

Per Server
Includes annual maintenance

Buy

70+ SSIS tasks and components

Task Factory Azure Data Factory

Annual Subscription License

 

$1,495 

Per ADF Node

 
Buy

65+ SSIS tasks and components