The level of detail in a fact table determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements, is called the:
A) span.
B) grain.
C) selection.
D) aggregation.

Question

Quizplus · Accepted Answer

The grain of a fact table is the level of detail at which the data is stored. It is determined by the intersection of all the components of the primary key, including all foreign keys and any other primary key elements.

The Level of Detail in a Fact Table Determined by the Intersection