dimension table


Also found in: Dictionary, Thesaurus, Medical, Legal, Wikipedia.

dimension table

In a data warehouse, one side of the dimensional model set up for the department or organization. For example, the product dimension would be a list of the organization's products, the time dimension would be the calendar periods represented and so on. See dimensional modeling.
References in periodicals archive ?
Snowflake schema is refinement of star schema where some dimensional hierarchy is further splitting (normalized) into a set of smaller dimension tables (Fig 7), forming a shape similar to snowflake.
dimension table of subjects, dimension table of suppliers (including supplier code, supplier name, location, contact person, telephone, competent department, sales personnel, etc.
Given a particular dimension table Di, the members of the dimension are the values in this table and they are arranged in a hierarchy denoted <i.
Therefore, it's useful to create a dimension table that contains ranged values of critical recency, frequency and sales measures.
Key words: fact table, dimension table, star schema, star join, SQL query, multi-column index, and cardinality.
Together with his colleagues at Metaphor, Kimball designed his first fact and dimension table data warehouse, which was installed at Clorox in 1984.
Each dimension table has a "current row flag" regardless of whether the slowly changing dimension approach is Type 1 or Type 2 currently.
Sagent simplifies common loading tasks such as synthetic key generation, key lookup to confirm fact and dimension table data integrity, and time dimension creation.

Full browser ?