Data engineering·Modelling for analysis
the table has one row per order line, a handful of numbers you can add up, and the rest is foreign keys.
Fact table
Also calledfact, event table
The table holding the measurements of a business process — one row per occurrence, with numeric measures and keys pointing at the things being described. It is the big one, and everything about the warehouse's cost is decided by its grain and its partitioning. The test of whether something belongs in a fact is whether it is a number you would want to sum or average; if it is a label you would group by, it belongs in a dimension.