The process involved in the implementation of SCD Type 3 in informatica is
We will see the implementation of SCD type 3 by using the customer dimension table as an example. The source table looks as
CREATE TABLE Customers ( Customer_Id Number, Location Varchar2(30) )
Now I have to load the data of the source into the customer dimension table using SCD Type 3. The Dimension table structure is shown below.
CREATE TABLE Customers_Dim ( Cust_Key Number, Customer_Id Number, Curent_Location Varchar2(30), Previous_Location Varchar2(30) )
Steps to Create SCD Type 3 Mapping
Follow the below steps to create SCD Type 3 mapping in informatica
New_Flag = IIF(ISNULL(Cust_Key),1,0) Changed_Flag = IIF(NOT ISNULL(Cust_Key) AND Prev_Location != Curr_Location, 1, 0 )