What is the difference between Type 1 and Type 2 Slowly Changing Dimensions (SCD)?
- Creates a new record for each change
- Deletes old records
- Only updates the current record
- Retains historical data in a separate table
The key difference between Type 1 and Type 2 SCD lies in handling changes. Type 1 updates the current record, overwriting old values, while Type 2 creates a new record for each change. This preserves historical data, allowing analysis of data changes over time.
Loading...
Related Quiz
- Scenario: A startup company with limited resources is looking for a cost-effective solution for database design and management. They prioritize ease of use and flexibility. Which database design tool would be most suitable for their needs, and what features make it a good choice?
- The process of removing redundant data and ensuring data integrity in a database is known as _______.
- Conceptual schema design aims to create a high-level __________ of the database.
- Scenario: An e-commerce website needs to store product information, including details like name, price, description, and customer reviews. The website experiences heavy read traffic due to frequent product searches. Which type of database would be most appropriate for this use case?
- What is a column-family store in NoSQL database systems?