Interested to Buy Any Domain ? << Click Here >> for more details...
What is Grain & Granularity in Data Warehouse.
- 2 Answers
- 46349 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
Why fact table is in a normal form?
Explain differences between star and snowflake schemas?
What are diagrams?
Database in use is oracle?
How to design file watch jobs?
What is data warehosuing hierarchy?
Explain the definition of normalized and denormalized view and what are the differences between them?
How many types of facts and what are they?
what are different storage options supported by oracle ?
What is Active Datawarehousing?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
What is degenerate dimension table?
in general which algorithms for used?
What is many-to-many dimensional model in datawarehousing ?
what are the all possible features supported modify stage?
