4.Explain Snowflkeschema ?
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
what are the all possible features supported modify stage?
Database in use is oracle?
Explain when do we analyze the tables? How do we do it?
what are the different views that are considered when building an object-oriented software system?
What is a view as it relates to system modeling?
Explain how to get the first 100 rows from the flat file into the target?
What is the difference between er modeling and dimensional modeling?
Can any one explain the hierarchies level data warehousing.
How to design file watch jobs?
Explain multivalued dependency?
How to drill through from a powerplay cube to reportnet?
Explain what are the advantages data mining over traditional approaches?
How to generate the cubes in framework manager?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Who needs data warehousing?