ravi

• Mar 11th, 2007

 

In type-1 dimesnion we have only the current dimension data.We overwrite the the old dimension data with the new dimension.

In type-2 , we basically keep the entire history of data and for we add additional row to the changed dimension as a new row with the changed values.

In short it keeps the full historical data what happened before.

vizaik

 Profile Answers by vizaik 

• Mar 21st, 2007

 

there are 3 scd types
scd type1:  Only current details
scd type2:  History + current details
scd type3:  Initial + current details




In projects, we mainly use scd type1

versionking

 Profile Answers by versionking 

• Feb 19th, 2010

 

Type 1: Update with current data.
Type 2: Stores history ie all past and current data.
Type 3: Prev data and current data only.