QuestionQ65

VerifiedPrepare data

You need to create a data loading pattern for a Type 1 slowly changing dimension (SCD).

Which two actions should you include in the process? Each correct answer presents part of the solution.

NOTE: Each correct answer is worth one point.

Choose two
Explanation

Type 1 SCD (Slowly Changing Dimension) does not preserve history; it overwrites data. The two required actions are updating existing rows when non-key attributes change (A) and inserting new records for new natural key values (D). Options B and C involve effective date tracking and history preservation, which are Type 2 SCD characteristics. Type 1 dimensions maintain only the current state.

Community Discussion

No comments yet. Be the first to start the discussion!