Multiple choice technology platforms and products

Slowly Changing Dimensions(SCD) stage supports________________________

  1. Type1 & Type2 SCD

  2. Only Type1

  3. Only Type2

  4. Type1,Type2,Type3
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DataStage's Slowly Changing Dimensions (SCD) stage primarily supports Type 1 (overwrite existing record, no history tracking) and Type 2 (add new record with timestamp/effective date, maintain history). Type 3 (add new column to track changes) is less commonly supported in the standard SCD stage implementation and typically requires custom logic or different stage configuration.

Keep practicing — related questions