Create/Implement SCD – Informatica Mapping Wizard

  • Updated
  • Posted in Programming
  • 3 mins read

Q) How to create several types of slowly altering dimensions (SCD) in informatica utilizing the mapping wizard?


The Mapping Wizards in informatica supplies a straightforward approach to create the several types of SCDs. We will see how you can create the SCDs utilizing the mapping wizards in step-by-step.


The beneath steps are widespread for creating the SCD sort 1, sort 2 and kind 3


Open the mapping designer instrument, Go to the supply analyzer tab and both create or import the supply definition. As an instance i’m utilizing the shopper desk because the supply. The fields within the buyer desk are listed beneath.


Customers (Customer_Id, Customer_Name, Location)


Go to the mapping designer tab, within the instrument bar click on on Mappings, choose Wizards after which click on on Slowly Changing Dimensions.



Now enter the mapping identify and choose the SCD mapping sort you wish to create. This is proven within the beneath picture. Then click on on Next.



Select the supply desk identify (Customers on this instance) and enter the identify for the goal desk to be created. Then click on on subsequent.



Now you need to choose the logical key fields and fields to match for modifications. Logical key fields are the fields which the supply qualifier and the Lookup shall be joined. Fields to match for modifications are the fields that are used to find out whether or not the values are modified or not. Here i’m utilizing customer_id because the logical key area and the situation as the sector to match.


As of now we have now seen the widespread steps for creating the SCDs. Now we are going to see the precise steps for creating every SCD


SCD Type 1 Mapping:


Once you’ve chosen the logical key fields and fields to match for modifications. Then you need to merely click on the end button to create the SCD Type 1 mapping.



SCD Type 2 Mapping:


After choosing the logical fields click on on the subsequent button. You will get a window the place you may choose what sort of SCD 2 you wish to create. For

  • Versioning: choose “hold the model quantity in separate column”
  • Flagging: choose “Mark the present dimension file with a flag”
  • Effective Date: choose “Mark the dimension information with their efficient date.


Once you’ve chosen the required sort, then click on on the end button to create the SCD sort 2 mapping.



SCD Type 3 Mapping:


Click on the subsequent button after choosing the logical key fields. You will get window for choosing the elective Effective Date. If you need the efficient date to be created within the dimension desk, you may examine this field or else ignore. Now click on on the end button to create the SCD sort 3 mapping.


Leave a Reply