In Slowly Changing Dimensions (SCD), Type 1 only _______ existing records.
- deletes
- inserts
- modifies
- updates
In Type 1 Slowly Changing Dimensions (SCD), only updates existing records. When there is a change in the source data, the existing record in the dimension table is directly updated with the new information, and there is no maintenance of historical data.
Loading...
Related Quiz
- How does a composite key differ from a single-column key in a database?
- How does SQL handle data manipulation compared to UML?
- The relationship between a department and an employee in a company database is typically _______.
- In a fact table, surrogate keys are used instead of _______ keys to uniquely identify each record.
- What does SQL stand for in the context of data modeling languages?