Task Factory

Dimension Merge SCD Transform

Dimension Merge SCD is a powerful replacement for the native Slowly Changing Dimension (SCD) wizard in SSIS.

Task Factory
Call Us At: (904) 413-1911

Contains 65+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.

Per server
Per server

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

Testimonial What People Say About Task Factory

“We got Task Factory mostly because of Pragmatic Works reputation for the service they provide and the specific need of a secure SFTP task.”

Matt Cushing
Matt Cushing
Loews Corporation

“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
Gabriel Gray
University of Calgary

Our Clients 96% of fortune 100 companies trust pragmatic works:

Our StatsSome of our cool facts

  • 200x
    More frequent deployments
  • 24x
    Faster recovery from failures
  • 3x
    Lower change failure rate
  • 2555x
    Shorter lead times

Articles & Tutorials

Task Factory Transforms SSIS to a True Data Warehouse Solution for the University of Calgary

In this case study, you'll learn how Pragmatic Works' Task Factory helped the University of Calgary transform SSIS into a true data warehouse solution. Read More

Webinars & Videos

How to Use the Dimension Merge SCD
Building a Better Data Warehouse with SSIS Advanced Components
Accelerate SSIS today
Task Factory Standard Edition
Help Documentation
Download Data Sheet

Please reach out to us to start your digital transformation journey.