Search This Blog

Wednesday, January 12, 2011

Slowly changing dimension

SCD means Slowly Changing Dimension.

SCD-1 (Current)
 
Overwriting the old values in the dimension record.
SCD-2 (History and Current)
Creating an additional dimension record at the time of the change with the new attribute values.
SCD-3 (Previous and Current)
Creating new current fields and move the old attribute in a precedent field.


No comments:

Post a Comment