Answer-first summary for fast verification
Answer: Update rows when the non-key attributes have changed., Insert new records when the natural key is a new value in the table.
Type 1 Slowly Changing Dimensions (SCDs) involve updating existing records without maintaining historical data. Therefore, any changes to non-key attributes should result in updating the existing row (Option A). Additionally, new records for new natural key values should be inserted into the table (Option D). Options B and C pertain to Type 2 SCD, which maintains historical records.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of creating a data loading pattern for a Type 1 Slowly Changing Dimension (SCD), which primarily involves updating the existing records without keeping any historical data, which two actions should be included in the process? Each correct answer represents a portion of the complete solution. NOTE: Each correct answer is worth one point.
A
Update rows when the non-key attributes have changed.
B
Insert new rows when the natural key exists in the dimension table, and the non-key attribute values have changed.
C
Update the effective end date of rows when the non-key attribute values have changed.
D
Insert new records when the natural key is a new value in the table.
No comments yet.