Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46198 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 |
waht is the advantage of infoset query
wht is degenerated dimension ?it's uses?
Explain what is the difference between a primary and secondary actor in use case modeling?
Can you explain how analysis service works?
if you use oracle sql*loader , how do you transform data with it during loading?
What are partition points?
What is the use of incremental aggregation? Explain me in brief with an example?
What is meant by metadata in context of a data warehouse?
Explain what are slowly changing dimensions?
what type of raid setup would you put your tx logs?
What is conformed fact?
What is perform recovery?
Teradata 
