Which slowly changing dimension (SCD) type overwrites the old attribute value without preserving history?

SQL Data Analyst Hard

SQL Data Analyst — Hard

Which slowly changing dimension (SCD) type overwrites the old attribute value without preserving history?

Key points

  • Type 1 SCD does not keep historical data.
  • Old attribute values are replaced by new ones.
  • Useful when historical data is not needed.

Ready to go further?

Start full exam Practice more questions

Related questions