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 a data profile?
Can you brief about the Data warehouse project you worked on?
What are the key features of chameleon that separates it from other algorithms?
What are vaious etl tools in the market?
What is called dimensional modelling?
What are the advantages of cold fusion?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What is Sequence clustering algorithm?
What is a core dimension?
How to generate the cubes in framework manager?
What is index awareness in universe?
What are the different types of data warehouses?
What is the difference between drill through and masterdetail reports?
How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?
Can a dimension table contain numeric values?
