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.
Loading...
Related Quiz
- Columnar databases are often favored in scenarios with heavy _______ operations due to their column-oriented storage.
- The process of ensuring that data is consistent, reliable, and usable during the ETL process is known as data _______.
- Which of the following is typically smaller in scope and focuses on a specific business area or department?
- Which BI functionality allows users to ask and answer their own questions without involving IT to create a new report?
- The process of cleaning and enhancing the data so it can be loaded into a data warehouse is known as what?