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

Type

Definition

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
BrioQuery
Data Warehouse Explorer

Glossary

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
Labels:
glossary glossary Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

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