When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a change is detected?

Question

Options

• Athe old record is deleted and the changed record is added
• Bthe old record is updated with the new values from the changed record
• Cthe old record is flagged and the changed record is added
• Dthe old record is merged with the changed record

• B
  4% (1)
• C
  91% (21)
• D
  4% (1)

Explanation

SCD Type 2 (Slowly Changing Dimension Type 2) preserves full history by flagging the old record as inactive (typically via an end date or active flag) and inserting the changed record as a new active row - so C is correct. Option A is wrong because deletion destroys history, which defeats the entire purpose of Type 2. Option B describes SCD Type 1, which overwrites old values with no history preserved. Option D (merging) isn't a recognized SCD pattern and would produce ambiguous, corrupted data.

Memory tip: Think "Type 2 = Two records exist." When a change happens, you end up with two rows for that entity - the old flagged one and the new active one. If you only ever have one row per entity, you're thinking of Type 1.

No community discussion yet for this question.