Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11428 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 have multiple application.cfm file in an application?
How to eliminate duplicate rows from flat file?
What are various warehousing tools?
How to drill through from a powerplay cube to reportnet?
What is aggregate fact table?
What is a data profile?
Code the tables statement to produce a multi-level frequency?
Explain the importance of data warehouse?
What a static and local variable?
How to design file watch jobs?
What are the various tools? Explain name a few?
What are the data types present in bo? What happens if we implement view in the designer n report?
Why should we use data ware housing and how can you extract data for analysis with example?
What is metadata in context of a datawarehouse and how it is important?
What is defined as partial backup?
