Which type of dimension change captures historical data without overwriting existing records?
- Type 1
- Type 2
- Type 3
- Type 4
Type 2 dimension change captures historical data without overwriting existing records. It adds new records for each change, including a surrogate key and an effective date range, allowing for historical analysis while preserving the original data.
Loading...
Related Quiz
- How does compression affect data retrieval speed in a database system?
- In an ERD, an _______ key is a key that consists of more than one attribute.
- What are the implications of having a mandatory relationship in terms of data integrity?
- In which normal form are all non-prime attributes fully functionally dependent on the primary key?
- Scenario: A team of data analysts needs to collaborate on designing a complex database schema using ER diagram tools. Discuss the collaborative features and project management functionalities that would be beneficial in this scenario.