A Dimension defines the entry point to analyze the facts and enable users to answer business questions.
A Dimension table is a collection of hierarchies and categories along which the user can drill down and drill up. It contains only the textual attributes. Dimension tables are nothing but a master tables through which extract the actual transactions. The dimension tables store the textual descriptions of the dimensions. Dimension tables, also known as lookup or reference tables; contain the relatively static data in the warehouse. Dimension tables store the information you normally use to contain queries.
No comments:
Post a Comment