please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
Answer Posted / padmalatha0923
star schema: it can be defined as a fact table sorrounded dy dimension tables and all the dimension tables should be de-normalised
snow flake schema: it can be defined as fact tables sorrunded by dimension tables and those dimension tables atleast one dimension table should be normalised
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How we drill up week to month?
What is package in BO
Explain the difference between detect alias and detect context?
what are the tables used in health care domain project and columns used in report?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What is report template in b.o?
What is difference between webi and infoview?
What we need to discuss with designer before starting the universe designing.
Explain what three things do you consider to be the most important factors for a manager?
What is object stores?
What is the difference between slice and dice and cross tab report?
Can we configure two instances of CMS pointing to two different CMS system databases?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain difference between zabo and webi?