Dimension Merge SCD

Parent Previous Next


Dimension Merge SCD Transform


Table of Contents

  Setup

  Memory Optimize Property

  Existing Dimension Input Tab

  Column Mapping Tab

  Row Change Detection Tab

   SCD2 Date Handling Tab

   Surrogate Key Handling Tab

   Inferred Member Behavior Tab

   Output Column Selection Tab

   Auditing Tab

   Logging Tab

   Performance Tab


New for version 4.2.0.405: The introduction of the Memory Optimized property. This is a significant change and we encourage all users to please read the Memory Optimized Property section before configuring the component.


The Dimension Merge SCD Transform is a custom Data Flow component used within SSIS to handle slowly changing dimension processing commonly used in Data Warehouses. While SSDT/BIDS provides a standard SCD component, users may experience limitations such as:


 Slow performance

 Re-running the SCD Wizard can destroy parts of the data flow

 Cannot be used against all data providers

 Difficulty in troubleshooting the standard component’s decision making abilities


Task Factory’s Dimension Merge SCD Transform maintains the functionality of the original SCD component while also providing:


 Better performance

 Non-destructive editing capabilities

 The ability to use a variety of data providers

 Improved UI that empowers users to customize the component’s configuration and view/troubleshoot decision-making

 Input/Output auditing

 Improved logging capabilities



Introducing the Sample Data


Introducing the Sample SSIS Package


Loading the Dimension Table with the SCD Wizard


Loading the Dimension Table with the T-SQL MERGE Command


Loading the Dimension Table with the Dimension Merge SCD Component