In Slowly Changing Dimensions (SCD), Type 4 utilizes an _______ table to store historical changes.
- Archive
- Audit
- Historical
- Snapshot
In Slowly Changing Dimensions (SCD) Type 4, a "Historical" table is used to store historical changes. This allows tracking changes over time while maintaining the current data in the main table. This type is beneficial when it's essential to preserve a complete history of changes.
Loading...
Related Quiz
- How does indexing improve query performance in a database?
- What is the difference between functional dependency and multi-valued dependency?
- Scenario: A database has a table with attributes {EmployeeID, ProjectID, HoursWorked}. Is this table in the third normal form (3NF)?
- What are some common techniques used to achieve eventual consistency in NoSQL databases?
- What role does the replication factor play in maintaining data consistency in NoSQL databases?