✍ Kashif M
Trends

Sunday, 16 February 2014


SCD TYPE 2 FOR VERSION IN INFORMATICA


By on February 16, 2014


1. In mapping designer click the mapping->wizards->slowly changing dimensions





2. Name the mapping and select the type of SCD







3. Select the source table from our source list and name the target table.





4. The source columns will appear as below.





5. Now move the source columns to logical keys and fields to compare for changes.


(i.e) 1. Add the key columns that will not change to logical keys fields


2. Add the columns that will change to the fields to compare for changes





6. Select the option for Version number.






7. The mapping will appear in mapping designer.






Generate the target table in target designer and save the mapping.

Kashif
mkashu: SCD TYPE 2 FOR VERSION IN INFORMATICA
Review : Kashif | Kashif
Update: February 16, 2014 | Rating: 4.5

Comment for "SCD TYPE 2 FOR VERSION IN INFORMATICA"

0 comments

Post a Comment

Blog Archive