What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 45260 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 |
Is union transormation is active transformation?
Hi,Please can u tell me.. What is the difference between a Hyperion Essbase CUBE and a Star Schema? Thanks in advance, Vijay.
Can you pass sql queries in filter transformation?
what is the difference between MOLAP and ROLAP?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what is difference between query studio and report studio?
What is recovering sessions?
What are the difference between snow flake and star schema?
The same tier?
How to provide security in frame work manager for a query subject?
How to pivot data using informatica when you have variable amount of pivot rows?
Explain me what are conformed dimensions?
Teradata 
