Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46137 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 is the working process for application.cfm?
How many types of facts and what are they?
Explain what are the modules in power mart?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
How to pivot row data using informatica?
What is a linked cube?
I know of using applysimple, but there are other ways too?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
What is scd1 , scd2 , scd3?
Explain normalization?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
How can we import and export using BCP utility?
Teradata 
