Which dimension change type in SCD involves creating a new record for each change, thus preserving historical data?
- Type 1
- Type 2
- Type 3
- Type 4
In Slowly Changing Dimensions (SCD), Type 2 involves creating a new record for each change. This method ensures that historical data is preserved, as each version of the record is stored with its effective start and end dates.
Loading...
Related Quiz
- Which factor is NOT typically considered during storage optimization?
- Graph databases excel at modeling and querying data with complex _______ structures.
- Which property of graph databases makes them particularly suitable for recommendation systems and social networks?
- How does the concept of slowly changing dimensions (SCD) relate to fact tables?
- In specialization, what does the term "subtypes" refer to?