General Datawarehousing Interview Question:

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

Submitted by: Administrator

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
Submitted by: Administrator