Which type of Slowly Changing Dimension (SCD) uses a separate table to store both current and historical data for an attribute?
- SCD Type 1
- SCD Type 2
- SCD Type 3
- SCD Type 4
SCD Type 2 is the type of Slowly Changing Dimension that uses a separate table to store both the current and historical data for an attribute. It allows you to maintain a historical record of changes over time while preserving the current value in the main table. This is particularly useful in data warehousing for tracking changes to dimension attributes.
Loading...
Related Quiz
- In a logical model, the relationship between two entities where one occurrence of entity A can relate to many occurrences of entity B, and vice versa, is termed as _______.
- In a data warehouse, a _______ is a large, subject-oriented, integrated, time-variant, and non-volatile collection of data that supports decision-making.
- For an organization that requires immediate insight into business operations, which type of BI would be most appropriate?
- In the context of data warehousing, the term _______ refers to a set of standards and technologies that ensure data remains confidential and hasn't been tampered with.
- A company is designing a data warehouse and wants to ensure that query performance is optimized, even if it means the design will be a bit redundant. Which schema should they consider?