What is a degenerate dimension?
- A A dimension attribute such as an invoice number stored in the fact table with no separate dimension
- B A dimension with missing values
- C An unused dimension
- D A dimension with only one row
Answer
A dimension attribute such as an invoice number stored in the fact table with no separate dimension
Transaction identifiers have no descriptive attributes worth a separate table, so they sit directly on the fact row.





