Dimension table

A dimension table is a data warehousing concept. It is one of the set of companion tables to a fact table.

The fact table contains business facts or measures and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.

The dimension tables contain attributes or (fields) used to constrain and group data when performing data warehousing queries.

References

• Kimball, Ralph et al; The Data Warehouse Lifecycle Toolkit(1998), p17. Pub. Wiley. ISBN 0-471-25547-5.