Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46348 Views
- TCS, TVS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / samir sabry
Grain The length of time (or other meaning) associated with
each record in the table.
The granularity is the lowest level of information stored
in the fact table. The depth of data level is known as
granularity. In date dimension the level could be year,
month, quarter, period, week, day of granularity.
The process consists of the following two steps:
- Determining the dimensions that are to be included
- Determining the location to place the hierarchy of each
dimension of information
| Is This Answer Correct ? | 39 Yes | 21 No |
Answer / srinivasan manoharan
Grain and Granularity mean the same. It reflects the level
of detail in data warehouse.
| Is This Answer Correct ? | 36 Yes | 21 No |
What are templates in which way it is help full?
How to design file watch jobs?
Explain what is batch and describe about types of batches?
what is parallel query?
Explain what is the difference between stop and abort?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What are the design methods of data warehousing?
What are the steps involved in designing a fact table?
Explain what are the different types of data warehousing?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Can any one explain the hierarchies level data warehousing.
Teradata 
