What is a level of Granularity of a fact table?
Answer
A fact table is usually designed at a low level of Granularity. This
means that we need to find the lowest level of information that can store in a
fact table.
E.g. Employee performance is a very high level of granularity.
Employee_performance_daily, employee_perfomance_weekly can be considered lower
levels of granularity.
|