Access Keys:
Skip to content (Access Key - 0)



Data Warehouse term: Refers to how tables are used in constructing queries.

The table types "Fact" and "Dimension" refer to how tables are used in constructing queries.

A Fact table is typically the center of a subject area and contains values which are to be measured by a query (e.g. Purchase Order Dollar Amount, Financial Transaction Actual Amount, Count of Students, Test Score). Information which is to be summed and totaled on a report usually resides in the central Fact table.

A Dimension table typically contains master data (such as GL Accounts, Cost Collectors, Academic Terms, Department Names). Dimension tables are used to provide different groupings or categorizations on a report and to limit queries by choosing only the desired sets of data (e.g. choosing a particular fiscal period or small set of account numbers).

See also

Data Warehouse
Data Warehouse Explorer


Provides definitions for common IT terms and acronyms

Last Modified:

March 24, 2011

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
glossary glossary Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
This product/service is:
Easy to use
Difficult to use

This article is:
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki