Data engineering·Modelling for analysis
everything you would ever put in a group-by or a filter — country, product name, channel — lives in one wide, short table.
Dimension table
Also calleddimension, lookup table
The table describing the context of a fact: who, what, where, which. Dimensions are small, wide and heavily denormalised on purpose, because the join to them is on every query and the redundancy is cheap compared to a second hop. When someone complains that the warehouse has 'duplicated' the product name in three places, this is usually the answer, and it is deliberate.