Facts and dimensions
Version:
Facts and dimensions are data warehousing terms. A fact is a quantitative piece of information - such as a sale or a download. Facts are stored in fact tables, and have a foreign key relationship with a number of dimension tables.
Dimensions are companions to facts, and describe the objects in a fact table. In the following example, every download fact is linked by ID to a number of dimensions:
