Question
An order number is stored in a fact table for drill-through but has no separate descriptive table. What is it?
Select an option. Your answer will be checked instantly.
Correct Answer: A. A degenerate dimension
Explanation:
A degenerate dimension is a business identifier retained directly in the fact table.
It has analytical value but no additional attributes requiring a dimension table.
Leave a Reply