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