Why might a fact table contain surrogate keys that reference dimension tables?

  • To improve data quality
  • To reduce storage space
  • To simplify query writing
  • To support slowly changing dimensions
Fact tables may contain surrogate keys that reference dimension tables to support slowly changing dimensions (SCDs). Surrogate keys provide a stable reference to dimension data, even when the source dimension data changes. This is essential for historical analysis and maintaining data consistency in the data warehouse.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *