medium10 pts · first answer countsdata-warehousingdimensional-modelling
Summing account balances over time
A daily snapshot fact stores each bank account's closing balance. An analyst sums balance across all 31 days of March to get March's balance. What is wrong?
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