Question
Why should the grain of a fact table be declared before choosing measures?
Select an option. Your answer will be checked instantly.
Correct Answer: A. It defines exactly what one fact row represents
Explanation:
Measures must be valid at the row’s declared level of detail.
An unclear grain leads to mixed-level facts and incorrect aggregation.
Leave a Reply