Table des dimensions

Définition

Dimension tables are the entry points into the fact table. [...] The dimension implement the user interface to the data warehouse. (Kimball, Ross, 2008, p.20)[1]

Exemple

Exemple de table de dimension (Kimball, Ross, 2008, p.20)

ConseilIntelligibilité

The best attributes are textual and discrete. Attributes should consist of real words rather than cryptic abbreviations. (Kimball, Ross, 2008, p.20)[1]