For a dimension where the historical data is not tracked and only the current value is retained, which type of Slowly Changing Dimension (SCD) is implemented?
- SCD Type 1
- SCD Type 2
- SCD Type 3
- SCD Type 4
In cases where only the current value is retained in a dimension and historical data is not tracked, you would implement a Slowly Changing Dimension (SCD) Type 1. This type overwrites the existing data with the new data without maintaining a history.
Loading...
Related Quiz
- The practice of regularly verifying the accuracy, consistency, and reliability of data in a data warehouse is known as _______.
- The process of transforming data from source systems into a format suitable for analysis in a data warehouse is known as _______.
- What is the primary purpose of a physical data model?
- Which OLAP operation involves viewing the data cube by selecting two dimensions and excluding the others?
- In BI reporting, what type of visualization would best represent the distribution of sales over a year?