medium10 pts · first answer countsdata-warehousingdimensional-modelling
Choosing the grain of a fact table
An orders system has orders, each with several line items. Analysts need sales by product. What grain should the sales fact table have?
Discussion 0
Join free to post in the discussion.
Related questions
- A fully additive measureData Engineer
- Invoice number in the fact tableData Engineer
- Why keep a date dimensionData Engineer
- One customer dimension for two factsData Engineer
- Kimball versus InmonData Engineer
- OLTP and OLAP workloadsData Engineer
- Why warehouses store columnsData Engineer
- Facts and dimensionsData Engineer