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
Explain differences between star and snowflake schemas?
What are vaious etl tools in the market?
What are fundamental stages of data warehousing?
Explain difference between data ware house & data mart?
What are the different types of segments?
How can you communicate with web server (apache or iis) from coldfusion?
Explain is fact table?
What is informatica architecture?
Could any one explain me how to create cascading prompts?
Is there any rownum object from which we can do this?
what are the all possible features supported modify stage?
Explain how are the dimension tables designed?
Describe the differences between a data warehouse and data mart.
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
What are the advantages of query studio compared to report studio?