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 Scope of Analysis

8 Answers   TCS,


without creating the business view is there possible to create & generate the Crystal reports?

3 Answers   TCS,


CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?

0 Answers  


3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,


Explain the difference between compatible and incompatible objects?

0 Answers  






any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....

2 Answers  


can any one tell me how to create a new universe from scrach with step by step process.

4 Answers   HCL,


What is drill across ? can anybody explain me in detail?

1 Answers  


What Is Snow Flake Schema?

0 Answers   Informatica,


HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers  


What are different types of saving options in web intelligence?

7 Answers  


Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,


Categories