Answer Posted / srini madhala
Star Schema:In Star shema we have fact table sorrounded by
diemension table.Since the shape looks as a star its called
as star schema
Snow Flake Schema:
in Snow flake schema we have fact table sorrounded by
diemension table and the diemensional table have their child
diemensions.Its denormalized
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the message flows?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is the difference between Standard and Metrics folder?
how you provide security to reports? How you provide security to packages ?
What are the types of hierarchies?
What are various types of gateways in cognos?
Can you define drill across?
What is model?
What is difference between content store and content manager?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Explain the difference between powerplay transformer and power play reports?
how can I test reports in cagnos?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
What is the difference between low affinity and high affinity connections?