What is the difference between type 1& type 2 dimension

Showing Answers 1 - 0 of 0 Answers

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.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions