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 fact table in data ware house is it describes the transaction data. It contains characteristics and key figures.
|
A dimensional table is a collection of hierarchies and categories along which the user can drill down and drill up. it contains only the textual attributes. |
