What is the difference between type 1& type 2 dimension

Showing Answers 1 - 0 of 0 Answers


  • 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


  • 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