Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11414 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / nrkreddy
snow flake shema is nothing but fact table is sourrended by
dimension table getting the lowest level of the
information
snow flake sehema is used for getting the details From
lowest level of Grunularity
in the sense we will get the data from the detailed level
For example : TIME
a Fact table is associated with TIME Dimension up to month
granulary in the sence this DIM table having
year-->Quater-->month
beut we need the information Up to a day in this senario we
will go Snowflake shema is sliced deeply up to the Day
year-->Quater-->month-->week-->Day
here the dimension table
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we start and stop single session in concurent bstch?
Difference between cold fusion 5 and cold fusion mx 6?
Explain me what is vldb?
Explain reference cursor?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain about core dimension,
Can we take backup when the database is opened?
What is load manager?
Explain what is the advantages data mining over traditional approaches?
How to export mappings to the production environment?
What are snapshots? What are materialized views & where do we use them?
How can we determine what records to extract?
How to know the time taken for particular report execution?
What is cfapplication tag?
Explain what is the difference between stop and abort?
