Fact table

A fact table contains the numeric measures of the activity (quantity, amount) and the keys to the dimensions, without repeated descriptive attributes. It is often large, at a defined grain, and serves as the basis for the model's measures.

Example

Ventes: DateCommande, IdProduit, IdClient, Quantité, Montant

Related concepts

The whole glossary