Dimension table

The attributes in a dimension table describe all the different specific properties or characteristics of this dimension. Most often -in a star schema- the dimension tables are de-normalized.