Vous êtes ici

Fact table

A fact table contains all numeric information for one single business process in context of multiple related dimensions.eg. a sales fact contains number of sold quantities, revenue, margin, etc.

The granularity is ideally kept as low as possible in order to enable a variety of reports and analyses.