What is the level of granularity of a fact table?

The granularity of a fact table is generally kept to a minimum. This implies we must determine the smallest amount of data that can be recorded in a fact table, such as employee performance, which has a very high level of granularity. Lower degrees of granularity are employee performance daily and employee performance weekly.

The granularity of the information recorded in the fact table is the lowest degree of detail. Granularity refers to the depth of a data level. The amount of granularity in the date dimension might be year, month, quarter, period, week, or day.

The process consists of the following two steps:

  • Determining the dimensions that are to be included
  • Determining the location to find the hierarchy of each dimension of the information

The above factors of determination will be re-sent as per the requirements.