Feature_Part_of-Product_Logos_Task_Factory (1)

 

Task Factory Feature: Dimension Merge SCD Transform

 

FREE TRIAL
BUY

Movet iudico et eos, porro detraxit atomorum te quo, ad cum eripuit delectus.

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

HELPFUL LINKS

Help Documentation

Data Sheet

 

Please reach out to us for more information or a personalized demo.

+1 (704) 895-6241

 

FREE TRIAL

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 depthinterface 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 Buying Options

 

Contains 60+ 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.

 

Standard

$1,795

Per Server

+

$359

for the first year of annual maintenance

$2,154

due at checkout

30+ SSIS tasks and components

BUY

Pro

$2,495

Per Server

+

$499

for the first year of annual maintenance

$2,994

due at checkout

60+ SSIS tasks and components

BUY