What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 45258 Views
- TCS, TVS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is called data cleaning?
Explain ddl (data definition language)?
Can you brief about the Data warehouse project you worked on?
Explain difference between e-r modeling and dimentional modeling?
What are the different methods of loading dimension tables?
How to eliminate duplicate rows from flat file?
What is difference macros and prompts?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Define Data Warehousing?
what is parallel query?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
what are the all possible features supported modify stage?
What is a relationship?
