In data warehousing, a fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables. Where multiple fact tables are used, these are arranged as a fact constellation schema.
Fact tables provide the (usually) additive values that act as independent variables by which dimensional attributes are analyzed. Fact tables are often defined by their grain. The grain of a fact table represents the most atomic level by which the facts may be defined. The grain of a SALES fact table might be stated as "Sales volume by Day by Product by Store". Each record in this fact table is therefore uniquely defined by a day, product and store. Other dimensions might be members of this fact table (such as location/region) but these add nothing to the uniqueness of the fact records. These "affiliate dimensions" allow for additional slices of the independent facts but generally provide insights at a higher level of aggregation (a region contains many stores).
Read more about Fact Table: Example, Measure Types, Types of Fact Tables, Steps in Designing A Fact Table
Famous quotes containing the words fact and/or table:
“What arouses the indignation of the honest satirist is not, unless the man is a prig, the fact that people in positions of power or influence behave idiotically, or even that they behave wickedly. It is that they conspire successfully to impose upon the public a picture of themselves as so very sagacious, honest and well-intentioned.”
—Claud Cockburn (1904–1981)
“... So damn your food and damn your wines,
Your twisted loaves and twisting vines,
Your table d’hôte, your à la carte,
. . . .
From now on you can keep the lot.
Take every single thing you’ve got,
Your land, your wealth, your men, your dames,
Your dream of independent power,
And dear old Konrad Adenauer,
And stick them up your Eiffel Tower.”
—Anthony Jay (b. 1930)