Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shubhamw
According to my findings, the key difference between SCD type 2 and type 3 is in their ability to maintain historical records. SCD type 2 is capable of storing multiple versions of a record, while SCD type 3 may only retain the current version and one previous version. However, there is some ambiguity regarding how many records SCD type 3 can hold.
To clarify, a good rule of thumb is to use SCD type 3 when the number of historic records that need to be retained is known in advance for e.g. If you need to store 5 records per user_id then the data structure is going to remain consistent over time i.e. 5 records hence implementing type 3 SCD will be a better choice. Conversely, if the number of records per user_id is uncertain, SCD type 2 may be a better choice.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an error log table in informatica occurs and how to maintain it in mapping?
What is dimensional modelling?
How we are using this function?
How are the dimension tables designed?
Explain the differences between normalizer and normalizer transformation?
Suggest a good author for hyperion in data warehousing?
What is load manager?
What is Star Schema?
What is data analysis?
What is the difference between star and snowflake schemas?
Explain where do we use semi and non additive facts?
How to provide security in frame work manager for a query subject?
Explain why dimenstion tables are denormalized in nature?
Explain hybrid slowly changing dimension?
What are necessary tasks to install reportnet software?
