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 difference macros and prompts?
What is recovering sessions?
Explain what are the different methods of loading dimension tables?
What are the key columns in Fact and dimension tables?
Which component has onread method and what it is used for?
What is a cube in data warehousing concept?
Explain me what are data marts?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is Star Schema?
What is the limit to the number of sources and targets you can have in a mapping?
What are session timeout and application timeout? Where we have to do this process?
What is the difference between power center & power mart?
in general which algorithms for used?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
