In a fact table, surrogate keys are used instead of _______ keys to uniquely identify each record.
- Composite
- Foreign
- Natural
- Primary
In a fact table, surrogate keys are used instead of natural keys to uniquely identify each record. Surrogate keys are system-generated and provide a stable identifier, avoiding the complexities that can arise with changes in natural keys. This enhances the stability and efficiency of the data warehouse.
Loading...
Related Quiz
- 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?
- Which operation retrieves the value associated with a given key in a Key-Value Store?
- In an ERD, what does a cardinality constraint of "1 to Many" indicate?
- In what ways do database design tools facilitate collaboration among team members during database development?
- What are some advantages of using a column-family store over a relational database?