Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46203 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 |
Explain the main differences between star and snowflake schema?
what role views play in dimensional modeling?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is crass reference table?
How can we do ETL process in SQL Server?
What is the purpose of Dataware Control?
What is critical column?
What is ods (operation data source)?
Explain difference between snow flake and star schema.
Why is dimensional normalization not required?
What are fundamental stages of data warehousing?
How to define a cube??
Teradata 
