please differentiate star schema and snow fleak schema
with dimension table, how end user is depending on them in
creating reports.



please differentiate star schema and snow fleak schema with dimension table, how end user is depe..

Answer / 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

More Business Objects Interview Questions

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,


What is metrics?

2 Answers  


What is the definition of derived table ?

2 Answers   JPMorgan Chase,


wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.

2 Answers   Accenture,


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

0 Answers   Patni,






1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,


how to overcome overflow of data in a report

6 Answers  


what is meant by report busting

2 Answers   TCS,


IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?

4 Answers   TCS,


Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  


What is meant by data federator and what is the use of it?

2 Answers   TCS,


Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.

1 Answers  


Categories