Multiple choice technology platforms and products

Which type of SCD is ideal for a data warehousing project?

  1. Type 1

  2. Type 2

  3. Type 3

  4. All of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SCD Type 2 is ideal for data warehousing because it preserves complete historical change tracking by creating new records with effective date ranges. Unlike Type 1 (overwrites) or Type 3 (limited history columns), Type 2 enables time-travel queries and accurate historical analysis. This makes it the standard choice for dimension tables in enterprise data warehouses.

Keep practicing — related questions