Dimension Merge SCD Transform

Dimension Merge SCD is built to be a powerful replacement for the native Slowly Changing Dimension Wizard in SQL Server Integration Services (SSIS). This component includes a much more in-depth interface than the standard SCD Wizard and doesn’t need the OLE DB Command transformation. 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