Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46199 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
Explain what are non-additive facts in detail?
What are the different types of data warehouses?
Explain a relation schema and a relation?
How to generate the cubes in framework manager?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What should I have in mind when building olap solution from scratch?
Tell me what is degree of a relation?
How can you communicate with web server (apache or iis) from coldfusion?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
What is a Decision Tree Algorithm?
Explain what is data validation strategies for data mart validation after loading process?
Suppose we want to display zero when null values coming to report how can we do that?
Define data warehouse?
What is the very basic difference between data warehouse and operational databases?
Difference between cold fusion mx 6 and cold fusion mx 7?
