Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46246 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 the design methods of data warehousing?
what is difference between scd2 and scd3
Explain which are the olap tools available that are supported by oracle?
What are the primary ways to store data in OLAP?
What is a Decision Tree Algorithm?
What are cluster analysis in data warehousing?
Explain what are slowly changing dimensions?
What is a relationship?
What is Active Datawarehousing?
How to improve session performance in aggregator transformation?
What are the differences between datamart vs. Reporting cube?
Compare cold fusion with other programming languages?
Teradata 
