Fact table

A fact table records the events or measures of a business process (sale, click, order), with additive numerical values and keys to the dimensions. Its granularity, that is, what a row represents, must be precisely defined before any modeling. It is generally the largest table in the warehouse.

Example

One row of fait_ventes = one order line, with quantity, amount and customer, product and date keys.

Related concepts

The whole glossary