A degenerate dimension in a fact table does not have a corresponding _______ table.
- Dimension
- Lookup
- Master
- Reference
A degenerate dimension in a fact table does not have a corresponding dimension table. Instead, the dimension attributes are stored directly in the fact table. This is suitable when the dimension has no significant details other than its key and is not reused across multiple facts.
Loading...
Related Quiz
- Scenario: A database contains a table where the primary key consists of {OrderID, ProductID}, and there is an attribute called ProductDescription. Is this table in the second normal form (2NF)?
- Which of the following statements best describes denormalization?
- In an ERD, what does a cardinality of "One-to-One" signify?
- A financial institution is required to store transaction logs for regulatory compliance purposes. However, they have limited storage capacity. How can compression techniques help them manage their storage effectively while ensuring data integrity?
- How does partitioning contribute to storage optimization in distributed databases?