Skip to content
BENIBIX Learn

Dimension Table

Data🗄️ Storage & WarehousingDimensional Modeling

Also known as Dimension, Dim Table

A table that names the things in the facts, such as shops and dates.

Think of it like

It is like a phone book. It turns a code into a name, a place and other details.

Example

dim_product has one row per product, with its name, brand, size and colour. A report groups sales by brand using it.

Why it matters

Dimensions are what make numbers readable. Without them, a report shows codes instead of names.

Definition

A dimension table describes the things in your facts. Each row is one thing, such as one product, one shop or one day. It holds words people filter and group by, such as product name, city or month. A fact row points to it with a key. Dimension tables are short and wide, and change much less often than facts.
A star keeps each dimension in one table. A snowflake splits some of them again.

Common mistake

Putting numbers you add up in a dimension. Those belong in the fact table.

Key takeaways

  1. 1
    One row per thing. A product, a shop, a day.
  2. 2
    Words to filter by. Names, places and groups.
  3. 3
    Changes slowly. Far fewer updates than facts.

Compare