4.Explain Snowflkeschema ?
- 6 Answers
- 9476 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / sathish arichandran
Each Dimension table has been split into more than one
dimension and connected with centralized fact table. It has
bigger size than star schema. Dimensions are sliced
deeply with the business requirements.
But it is tough to understandable since it has more tables
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are fact, dimension, and measure?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is index awareness in universe?
What is vdl (view definition language) explain?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What needs to be done while starting the database?
Explain the difference between keylokup and joiner?
Explain clustering algorithm?
Explain the difference between dw and bi?
Explain why dimenstion tables are denormalized in nature?
What is defined as partial backup?
Explain where do we use semi and non additive facts?
Where the applications and where
Explain what are data marts?
