What is Grain & Granularity in Data Warehouse.
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
In document how to create metrics?
What is critical column?
What is data warehosuing hierarchy?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Define Data Warehousing?
How can you implement many relations in star schema model?
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain how many ways you create ports?
What is Active Datawarehousing?
What is type 2 version dimension?
Explain meta data?
How to improve session performance in aggregator transformation?
How can we run the graph? What is the procedure for that?
What is Sequence clustering algorithm?
Can we have multiple application.cfm file in an application?