Multiple choice technology platforms and products

In which type of SCD(Slowly changing dimensions) do we preserve history of data:

  1. Type One

  2. Type Two

  3. Type Three

  4. None of above

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Type 2 SCD preserves complete history by creating new records with effective dates when attribute values change. Type 1 overwrites old values (no history), Type 3 keeps limited history in separate columns.