SCD Type 1 Implementation using Informatica PowerCenter

• Real time example :
• Slowly Changing Dimension Type 1 do not preserve any history versions of data. This methodology overwrites old data with new data, and therefore stores only the most current information. In this article lets discuss the step by step implementation of SCD Type 1 using Informatica PowerCenter

• The number of records we store in SCD Type 1 do not increase exponentially as this methodology overwrites old data with new data  

Step1:create the source and target definitions show the below

Target table (Business reuqirment)

Step:2  From particular repository  to source and target drag into desinger show the below                             

     

Step 3:  create the one expression transformation connected to all ports from the source definition 

Step 4:

  create the one Lookup T/R and looking into target table TGT_CUST, and create the one port IN_CUST_ID,this  port keep into input and output both and also comming from expression t/r 

Set the properties 

Step 5:

1. once match the condtion in lookup transformation ,the return port is CUST_ID column ,this column connect to expression transformation.
2. Before create the Update strategy  transformation and drag the all ports from expression transformation should be except the CUST_ID column.and this column drag the from lookup t/r.
3. In update strategy transformation put the condtion in properties tab like.

Step 6: Keep into connected all ports from the update strategy t/r in to target.