Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11637 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
Explain what are necessary tasks to install reportnet software?
what are relationships?
Compare and contrast aggregates & indexes
How can we schedule the graph in unix?
What is drill-through?
What is the working process for application.cfm?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Why denormalization is promoted in universe designing?
What are algorithms provided by Microsoft in SQL Server?
What is the use of incremental aggregation? Explain me in brief with an example?
What is difference between model & package?
What is a linked cube?
How do you setup Lo-cockpit?
How to know the time taken for particular report execution?
What are the mapping paramaters and maping variables?
