This content has been marked as final. Show 6 replies
Dom Brooks wrote:I understand the difference, it just took me a while to shift gears in my brain.
Depends on context.
What do you think when someone says "give me a high level overview"?
No higher ... higher ... helicopter view...
When they talk about what level of detail to build warehouse tables to, it was not readily apparent what sense of level of detail was meant immediately.
I was confused when they first said build fact tables to the lowest level of detail possible, then figured it out when they said later that one can never report on a lower level of detail than the fact table, or something like that.
When processing graphical data/objects you talk about things very similarly, only the sense of the words is opposite. With high levels of detail meaning much larger storage and processing requirements.
You will have to get used to the convention. This is generally accepted convention.
Aggregating records by month is a higher level aggregation. (e.g. Total Sales for the month)
Reporting daily records (reporting each individual sale transaction) is a lower level -- a level that contains more detail and is more granular ("granularity" is another term you'll have to learn).
Hemant K Chitale