Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What are sample mappings for scd1,scd2 and scd3?




1384
views
asked marvit September 20, 2014 08:04 AM  

What are sample mappings for scd1,scd2 and scd3?


           

1 Answers



 
answered By vishnoiprem   0  
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.
The number of records we store in SCD Type 1 do not increase exponentially as this methodology overwrites old data with new data
Hence we may not need the performance improvement techniques.


Slowly Changing Dimension Type 2:
also known SCD Type 2 is one of the most commonly used type of Dimension table in a Data Warehouse.
SCD Type 2 dimension loads are considered to be complex mainly because of the data volume we process and because of the number of transformation
we are using in the mapping.

Slowly Changing Dimension Type 3:
preserves only few history versions of data, most of the time 'Current' and Previous' versions. The 'Previous' version value will be stored into the  additional columns with in the same dimension record.  In this article lets discuss the step by step implementation of SCD Type 3 using Informatica PowerCenter.
The number of records we store in SCD Type 3 do not increase exponentially as we do not insert a record for each and every historical record. Hence we may not need the performance improvement techniques used in the SCD Type 2 Tutorial.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert