What is Grain & Granularity in Data Warehouse.
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 difference between e-r modeling and dimensional modeling?
Explain can report net connect multiple datasource at a time in report creation time?
What is difference between Business Objects and Hyperion Essbase? Please help me
What are the different types of fact tables used in data warehousing?
What is a core dimension?
What are the different types of Fatcs? Explain with example only
Explain difference between e-r modeling and dimentional modeling?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
What are the advantages of cold fusion?
what are different types of partitioning in oracle ?
What is the difference between aggregate table and materialized view?
Can you explain how analysis service works?