what is the difference b/w star and snowflack schema in
dataware house?
Answer Posted / buttguru
The difference is in dimension tables and not the fact
table. Star schema contains denormalized dimension tables
while snowflake schema contains normalized dimension
tables, ie dimension tables are extended in snowflake
schema.
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what is the difference between business requirement document and use case document.
Explain what task is 98% of the required work of a business analyst?
explain in detail about type 3?
Explain the difference between union and group?
Difference between b.o 5.1 and 6.1b?
What is the dense rank?
what will be the contents for a functional requirements specifications
What is a bo repository?
Explain is there any default username & pwd for bo designer & supervisor?
What is report template in b.o?
Explain what are the measure objects?
What is the difference between slice and dice and cross tab report?
What is object stores?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?