Data Granularity

What is data granularity? Explain.

Questions by manju_thanneeru   answers by manju_thanneeru

Showing Answers 1 - 4 of 4 Answers

nikhilanshuman

  • Dec 9th, 2010
 

Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transaction level is usually referred to as atomic level data. Low granularity refers to data that is summarized or aggregated, usually from the atomic level data. Summarized data can be lightly summarized as in daily or weekly summaries or highly summarized data such as yearly averages and totals.

  Was this answer useful?  Yes

shri

  • Oct 18th, 2011
 

I am adding one more point to the above answer.Granularity refers to the level of detail of the data stored in any table .
Example :- Year > Month> Week> Day > Hour

In the same manner in real time project also have granularity in the data.

  Was this answer useful?  Yes

pari

  • Apr 26th, 2014
 

Explain data granularity and how it is applicable to data ware house?

  Was this answer useful?  Yes

Nutan Raut

  • Dec 15th, 2014
 

High level of detail-low level of granularity.& low level of detail-high level of granularity.


  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