Dimensional Data Modeling - Fact


A fact is a row in a fact table and represents an events.

A fact table represents a serie of facts.

The term fact comes from a joint research conducted by General Mills and Darmouth Univeristy in the 1960s.


  • In an event driven architecture, the events are facts.
  • In a database shared architecture, the tables store only the last version of the facts (ie mostly in dimensional/entity table)

Powered by ComboStrap