Question

Grain and duration have a direct impact on the size of ________ tables.

Answer 1

Grain and duration have a 'direct impact' on the size of fact tables.

Step-by-step explanation:

• In a fact table, the grain denotes the degree of details put in the fact table. A grain already holds a lot of data owing to its construction.

• It is constructed of numerous distinct yet interrelated elements.

• These elements are known as the primary element, the foreign element, and the other big and small elements.

• More the grain and duration, more is the size of the fact tables.

Answer 2

Grain and duration have a direct impact on the size of fact tables. A fact table consists of facts of a particular business process e.g., sales revenue by month by product. Facts are also known as measurements or metrics. It is located at the center of a star schema surrounded by dimension tables.