Implementation of slowly changing Dimension Type-2 Creating a new additional record to maintain the history (Using Start Date and End Date) using SCD Transformation in SSIS

In this demo we will see how to implement the SCD type 2 using SCD transformation.

Read: Implementationof slowly changing Dimension Type-2 Creating a new additional record tomaintain the history (Using Start Date and End Date) using SQL Merge statement.

https://bageshkumarbagi-msbi.blogspot.com/2022/05/implementation-of-slowly-changing_17.html

 Taking data flow task 

Taking source as OLEDB source and doing the configuration.

  

Now we are taking SCD transformation.

  

Select the business key and click on the next button.

 

Selecting historical changed attribute.

Click on the next button.

  

In case if we are selecting the flag then we are using above radio button.

Here we are using the start date and end date and also selecting the start date as Start time.

Click on ok button.

  

We are not enabling the inferred member support. Click on the next button.

  

Click on finish button.

Our package looks like below

  

Our package is ready to run.

Before running the package records in the Stage and main table as below.

  

Now running this package.

     

Package is executed successfully. See the records in the table.

  

Get the expected result.