General Datawarehousing Question:
Download Questions PDF

Explain What does level of Granularity of a fact table signify?

Answer:

Granularity
The first step in designing a fact table is to
determine the granularity of the fact table. By
granularity, we mean the lowest level of information
that will be stored in the fact table. This
constitutes two steps:

Determine which dimensions will be included.
Determine where along the hierarchy of each dimension
the information will be kept.
The determining factors usually goes back to the
requirements

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is a Fact table?Explain What are conformed dimensions?