How does SCD Type 2 preserve historical attribute changes?

SQL Data Analyst Hard

SQL Data Analyst — Hard

How does SCD Type 2 preserve historical attribute changes?

Key points

  • SCD Type 2 involves adding new rows for changes
  • Inactive rows are flagged or date-ranged
  • Ensures historical data is maintained accurately

Ready to go further?

Start full exam Practice more questions

Related questions