Dimensional Data Modeling - Fact

About

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.

Architecture

  • 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