SCD types and usages

What are the SCD types and what are its Usage?

Questions by Amithanbr   answers by Amithanbr

Showing Answers 1 - 3 of 3 Answers

pradeep16

  • Oct 21st, 2009
 

SCD - Slowly Changing Dimensions. SCD usages in data warehouse are to store the history of transactions on dimensions. There are three types SCDs:

Type1 - Just rewrite the record if there is a change in the existing dimension record,
Type2 -
Keep the original record and add the new record with new/old or insert update record stamp
Type3 -
Keep two records at any given point of time one for the old and one for the new

Hopefully that helps

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