Building dimensions

Building a dimension means grouping the descriptive attributes of an axis into a clean table, with one row per unique value and a key. You remove duplicates, avoid repeating these attributes in the fact table and organize the hierarchical levels (category, subcategory, product).

Example

Product table: IdProduit, Nom, Sous-catégorie, Catégorie.

Related concepts

The whole glossary