Type 3 Slowly Changing Dimensions (SCD) stores only the _______ value and the _______ value in the dimension table.
- current, original
- current, previous
- latest, former
- new, old
In Type 3 Slowly Changing Dimensions (SCD), only the current value and the previous value are stored in the dimension table. This allows for limited historical tracking by capturing the immediate previous state of the dimension attribute.
Loading...
Related Quiz
- The _______ constraint ensures that a value in a column matches one of a set of predefined values.
- Conceptual schema design is closely related to __________, ensuring the database accurately represents the real-world domain.
- What are some potential drawbacks of denormalization?
- In a superclass-subclass relationship, a _______ is a specialized version of a more general entity.
- How does Dimensional Modeling contribute to data warehouse performance?