Interested to Buy Any Domain ? << Click Here >> for more details...
4.Explain Snowflkeschema ?
- 6 Answers
- 11166 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
Fact table is in normalized or de-normalized form?
Explain what is the metadata extension?
What is the difference between view filter and report filter?
Can any one explain the hierarchies level data warehousing.
How to reduce warnings?
Can you brief about the Data warehouse project you worked on?
What are the mapping paramaters and maping variables?
Ist the schema that a data warehouse system can implements.
what is user variable in affinium campaign? and some real time examples.
Explain what are non-additive facts in detail?
What is Operational Data Store?
Explain what is a cube in data warehousing concept?
Explain conformed fact?
Compare aggregates and data marts
What is partitioning? What are the types of partitioning?
