What does level of Granularity of a fact table signify

Showing Answers 1 - 8 of 8 Answers

etl-new

  • Jun 24th, 2005
 

It describes the amount of space required for a database.

  Was this answer useful?  Yes

Kenneth

  • Jul 18th, 2005
 

Level of Granularity indicates the extent of aggregation that will be permitted to take place on the fact data. More Granularity implies more aggregation potential and vice-versa.

  Was this answer useful?  Yes

Sriharsha Hanumanth

  • Aug 24th, 2005
 

In simple terms, level of granularity defines the extent of detail. As an example, let us look at geographical level of granularity. We may analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET.

ravi kumar guturi

  • Mar 9th, 2006
 

Granularity means nothing but it is a level of representation of measures and metrics.

The lowest level is called detailed data

and highest level is called summary data

It depends of project we extract fact table significance

Bye

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions