Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46088 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 |
How many project sources we can create in metadata?
How much data hold in one universe.
Explain can a dimension table contains numeric values?
What function should we use to display the value entered or selected by a user in response to a prompt?
What is difference between query studio and report studio?
What is the difference between olap and datawarehosue?
What is the purpose of Dataware Control?
What are the various tools? Explain name a few?
Is union transormation is active transformation?
Is there any rownum object from which we can do this?
What is is a star schema?
Explain how to generate iqd file from framework manager?
Teradata 
