All Forums Tools
kiranparsha 16 posts Joined 04/09
13 Aug 2009
Scd type2

Hi all,How do we implement Scd type 2 in Teradata.Please let me know the process.Thanks,kiran

UpaMishra 35 posts Joined 01/08
28 Jan 2010

SCD-Slowly Changing DimensionIt is capturing the slowly changing data which changes very slowly with respect to the time. Example: The address of a custumer may change in rare case. The address of a custumer never changes frequently. There are 3 types of SCD.Type1- Here the most recent changed data is storedType2- Here the recent data as well as all past data (historical data) is storedType3- Here partially historical data and recent data are stored. it means, it stores most recent update and most recent history.As datawarehouse is a historical data, so type2 is more useful for it.

You must sign in to leave a comment.