Multiple choice technology architecture

What is the right granularity of a fact table?

  1. The granularity has to same as the business process

  2. The granularity must be an aggregate of the actual granularity of the business

  3. The granularity is decided based on the business needs and requirements from the data warehouse/mart

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Fact table granularity is determined by business requirements and the level of detail needed for analysis. It should align with what the business needs from the data warehouse, not necessarily match the raw business process granularity (too detailed) or be an aggregate (too summarized).

Keep practicing — related questions