What is a dimension table?
A dimension table is a database table that augments the data in a base record table mapped to a database table.
Dimension tables cannot be mapped to flat files and they cannot be joined to base tables mapped to flat files. Dimension tables and their corresponding base tables must be mapped to database tables in the same physical database (that is, the same data source).
For example, a dimension table might contain demographic information based on zip code, accounts belonging to a customer, or the customer's transactions, product information, or purchase transaction details.
When you define a dimension table, you specify the key fields for joining the dimension table to the base record table.
Copyright IBM Corporation 2015. All Rights Reserved.
