Respuesta :

lilaipo
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.

Answer:

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

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.

Otras preguntas