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 are the stages that are required in data warehousing?
What is the data type of the surrogate key?
What is drill-through?
Explain the different types of data warehousing?
Who needs data warehousing?
How can we run the graph?
Explain swot analysis?
How to drill through from a powerplay cube to reportnet?
How can you set the client management?
What are vaious etl tools in the market?
What are data modeling and data mining?
What is the very basic difference between data warehouse and operational databases?
What are the different types of schemas used in data warehousing?
Explain what are the possible data marts in retail sales?
What is Discover and Execute in XMLA?
