please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.
- 1 Answers
- 4660 Views
- Exilant, Wipro, I also Faced
- E-Mail Answers
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
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
What are all difference between business objects 6.5 and xi r2?
When to use local filter and when to use global filter?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is a fantrap in business objects?
Explain when we use aggregate awareness function in designer?
Explain is data mart?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Can we Save (save as) WEBI Doc as DESKI?
How would you format some text using css to be verdana and bold?
Can more than 1 metric be applied on an analytic in business objects?
What is the difference between slice and dice and cross tab report?
What Is The Difference Between Oltp And Olap?
explain in detail about type 3?
Can we create universe with no cache??
