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 create measures and dimensions?
What is the difference between Standard and Metrics folder?
What are the types of catalogs in cognos?
What is drill down and slicing and dicing whats the difference between them?
What is set to be Cognos configuration?
what is a prompt value in report studio and variables ?
How to publish a package by running Java Script?
Can you define cognos powerplay?
What are the components of report net?
What are initial page components of Cognos connection?
What are slice and dice?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
----------------Diff b/w Dimensional modeling and Relational modeling?
----------------Describe DWH Architecture?
What is the use of report studio?