Basics - What does level of Granularity of a fact table signify

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 25 of 116

What does level of Granularity of a fact table signify

Total Answers and Comments: 6

Last Update: March 07, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Sriharsha Hanumanth

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.

Above answer was rated as good by the following members:
cfo_2016

June 24, 2005 01:36:22

etl-new

RE: What does level of Granularity of a fact table signify

It describes the amount of space required for a database.

Is this answer useful? Yes | No

July 18, 2005 19:03:18

Kenneth

RE: What does level of Granularity of a fact table signify

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.

Is this answer useful? Yes | No

August 24, 2005 20:45:44

Sriharsha Hanumanth

RE: What does level of Granularity of a fact table signify

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.

Is this answer useful? Yes | No

1 0