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
how to perform back drill through in cognos 8 what is the use of it
What is difference between data mart and data warehouse?
What are various types of gateways in cognos?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
What is cognos reporting tool?
what is the difference between list report and crosstab report?
what are the features in cognos8ui
What are the themes in a data warehouse?
How do you improve the performance of the Cognos Analytics report
What is the use of cognos decision stream?
How to create model and how to test model?
Can you define a catalog and types of catalogs in cognos?
-----------------What is Direct and Conventional loading?
faq's on cognos
7. What is performance tuning?