Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46090 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
How to handle multi value dimensions?
what is user variable in affinium campaign? and some real time examples.
Explain what are non-additive facts?
Explain which columns go to the fact table and which columns go the dimension table?
How to drill through from a powerplay cube to reportnet?
What we will do with the universe for faster process?
What is the difference between metadata and data dictionary?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain can a dimension table contains numeric values?
What is data analysis?
Explain what is difference between query studio and report studio?
What are the difference between snow flake and star schema?
Explain what is the difference between a primary and secondary actor in use case modeling?
explain about balanced dimension,
Compare aggregates and data marts
