A transportation company wants to analyze its freight data. It has a fact table containing shipment weights, distances traveled, and delivery dates. How would you ensure that the fact table is appropriately linked to dimension tables representing locations, products, and time periods?
- Connect the fact table to location, product, and time dimensions using foreign keys
- Link the fact table only to location and product dimensions, omitting time dimensions
- Use natural keys for the fact table and dimension tables
- Use surrogate keys for all tables to ensure a unified link
To ensure appropriate linkage in a transportation company's scenario, foreign keys should be used to connect the fact table to dimension tables representing locations, products, and time periods. This enables comprehensive analysis by location, product, and temporal factors.
Loading...
Related Quiz
- What is the main purpose of a fact table in Dimensional Modeling?
- In relational database terminology, what does referential integrity mean?
- Which stage of database development involves transforming a high-level conceptual model into a detailed physical model?
- Scenario: A financial institution wants to analyze customer behavior patterns, including changes in account status and product subscriptions. Which Slowly Changing Dimensions (SCD) technique would you suggest and how would you implement it?
- What does the NOT NULL constraint specify in a column definition?