The Definitive Guid... | The Data Warehouse Toolkit:
These provide the context (the "who, what, where, when, and why") for the facts. Examples include Product , Date , Store , and Customer .
Determine exactly what one row in the fact table represents (e.g., one line item on a retail receipt). The Data Warehouse Toolkit: The Definitive Guid...
Kimball outlines a repeatable framework for designing dimensional models: These provide the context (the "who, what, where,