what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / raghu_nvs
Hi,
Star schema means centralized fact table joined with
different dimension tables.
snow flake schema means centralized fact table joined with
diff dimension tables, and again that dimension tables
joined with another dimension tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What Is The Difference Between Oltp And Olap?
Explain about a task that really tested your analytical abilities?
How were the reports scheduled and how to resolve unexecuted documents?
Explain how many universes can be created in a project?
What is the profile and package?
What is the dense rank?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain what is the difference between slice and dice and cross tab report?
What are the join problems comes appart from loop,chasm & fan Traps
When to use local filter and when to use global filter?
How would you format some text using css to be verdana and bold?
Explain is there any default username & pwd for bo designer & supervisor?
Explain what is the difference between business requirement document and use case document.
What three things do you consider to be the most important factors for a manager?
in sap bi we have wad, then why we go for sap bo