A table used in a star schema to store descriptive, hierarchical and metric information about an aspect of the business that is used for an analytical perspective. Common examples include product, customer, geography, and time. ()
A table in a “star†schema which, as a primary key, can be combined with other dimension tables in the same “star†schema to form a composite key to access or join information in the central fact table.
a data warehousing concept
A table that DB2 OLAP Server creates in your relational database that contains detailed information about the members in a dimension. There is one dimension table for each dimension in an outline.
Dimension tables describe the business entities of an enterprise, represented as hierarchical, categorical information such as time, departments, locations, and products. Dimension tables are sometimes called lookup or reference tables.
In dimensional modeling, a dimension is an aspect or perspective by which the facts may be accessed, selected, sequenced, grouped, filtered and presented; a collection of dimension levels.
table, typically in a data warehouse, that contains further information about an attribute in a fact table. For example, a SALES table can have the following dimension tables TIME, PRODUCT, REGION, SALESPERSON, etc. Also see Data Dimensions.
A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created.
A table in a star join schema with a single part primary key that is joined to a fact table.
A table that contains discrete values (usually a countable text field like school or degree). Also see fact table. Imagine viewing a spreadsheet. The row and column names would be the dimensions and the numeric data within would be the facts.
In data warehousing, a dimension table is one of the set of companion tables to a fact table.