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 |
Explain what are the different types of data warehousing?
What Oracle features can be used to optimize my Warehouse system?
What is the difference between metadata and data dictionary?
Explain what is the difference between view filter and report filter?
Difference between DSS & OLTP?
What are the different types of fact tables used in data warehousing?
What are the differences between datamart vs. Reporting cube?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
explain about dirty dimension?
What is meant by metadata in context of a data warehouse?
What is the working process for application.cfm?
1.WHAT IS DATA MART ?