|
What does level of Granularity of a fact table signify?
Data Warehousing Interview Questions and Answers
(Continued from previous question...)
What does level of Granularity of a fact table signify?
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
(Continued on next question...)
Other Interview Questions
| 