005·14

fact table

/fækt ˈteɪ.bəl/ - n.

1 [colloq.] The one table everyone trusts, named for a property no one has verified.Keep. Punchy.This is the problem.

Working definition

2. A table holding the measurements of a business process at a declared grain, with foreign keys to its dimensions.

Promoted

See also

additive measureA number the dashboard sums across every dimension, including the two where summing it means nothing.
dimension tableWhere the company keeps every adjective it has ever applied to a customer, none of them governed.
grainThe question 'what does one row mean?', asked far too late and answered by whoever wrote the query.
star schemaA clean diagram at the center of the deck, surrounded on all sides by the joins that did not fit on the slide.