Facts and dimensions

Current version: 9.2

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:

Dimensions linked to download facts

Do you have some feedback for us?

If you have suggestions for improving this article,