When a change in a dimension attribute results in marking the old record as inactive and inserting a new record with the changed data, it represents SCD type _______.
- SCD Type 1
- SCD Type 2
- SCD Type 3
- SCD Type 4
In Slowly Changing Dimension (SCD) Type 2, changes in dimension attributes are handled by marking the old record as inactive and inserting a new record with the updated data. This allows historical tracking of attribute changes.
Loading...
Related Quiz
- When discussing OLAP, which operation provides a summarization of data, increasing the level of abstraction?
- A retail company wants to understand the behavior of its customers. They have transactional data of purchases and want to find out which products are often bought together. Which data mining technique should they employ?
- In a traditional RDBMS, how is data primarily stored?
- Which OLAP operation involves viewing the data cube by selecting two dimensions and excluding the others?
- After profiling a dataset, a data analyst discovers that multiple columns have the same values in the same order, but with different column names. What should be the next step in the data cleaning process?