Question

The granularity of the fact is the __________ of detail at which it is recorded. a) transformation b) summarization c) level d) transformation and summarization

Answer 1

The granularity of the fact is the __________ of detail at which it is recorded.

a) transformation

b) summarization ✔️✔️✔️

c) level

d) transformation and summarization

Answer 2

The granularity of the fact is the (c) Level of detail at which it is recorded.

Definition of Granularity of the fact;

Granularity- is stored in fact table which is the lowest information.

Features of granularity of the fact;

• Granularity is the bottom of  data level. It can be month, year, week, day, and period.
• The fact table is desinged in low level.
• They are two types of factors included in granularity;

1. Includes the dimensions
2. the location to determine the information

• It is considered into levels, depths, scale, size that determines the quality of an object.

Hence, Granularity of the fact is acknowldeged in level of the lowest information in the fact table.