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
Can you explain cognos planning?
what is hints in cognos and where we use it.
What is cognos connection?
Can you define slice?
Explain the difference between native sql and cognos sql?
What is the enterprise class platform architecture of cognos 8?
What is Online View?
Can you define metrics designer?
How is cognos model organization works?
What is model?
What is the difference between a data mart and a data warehouse?
What do you understand by the term 'dynamic cube'?
Can you define pivot?
how you provide security to reports? How you provide security to packages ?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
