Basics - What is a level of Granularity of a fact table

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 24 of 113

What is a level of Granularity of a fact table

Total Answers and Comments: 3

Last Update: March 08, 2009

Sponsored Links

Best Rated Answer

—

Submitted by: Santanu Patra

It also means that we can have (for example) data agregated for a year for a given product as well as the data can be drilled down to Monthly, weekl and daily basis...teh lowest level is known as the grain. going down to details is Granularity

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

May 14, 2005 21:07:20

Nirav

RE: What is a level of Granularity of a fact table

Level of granularity means level of detail that you put into the fact table in a data warehouse. For example: Based on design you can decide to put the sales data in each transaction. Now level of granularity would mean what detail are you willing to put for each transactional fact. Product sales with respect to each minute or you want to aggregate it upto minute and put that data.

Is this answer useful? Yes | No

June 29, 2005 06:39:24

Santanu Patra

RE: What is a level of Granularity of a fact table

It also means that we can have (for example) data agregated for a year for a given product as well as the data can be drilled down to Monthly weekl and daily basis...teh lowest level is known as the grain. going down to details is Granularity

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 07, 2009 13:06:22

ibrarx

Member Since: March 2009 Contribution: 7

RE: What is a level of Granularity of a fact table

The smallest unit of analysis is called as 'grain'. Also known as the atomic unit of analysis. Deciding the grain and then on basis of it the aggregation level is called as the granularity of a fact table.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank