1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

when we go for snow flake schema rather than star schema ?

Question Posted / dvnarsingrao

Answers were Sorted based on User's Feedback



when we go for snow flake schema rather than star schema ?..

Answer / murali

snow flake schema is used for the dim tables contains more fields and the Dim_DB Tables are in the Normalization form.

Draw-back: Slow performance for executing the query.

Is This Answer Correct ?    1 Yes 0 No

when we go for snow flake schema rather than star schema ?..

Answer / babu

whether the schema contains in normalized form and data should be redundancy is required then we go for snow flake schema and the dimension table should split into another child table in this situation we go for snowflake schema rather than star schema.

Is This Answer Correct ?    1 Yes 0 No

when we go for snow flake schema rather than star schema ?..

Answer / smiley

When we have multiple tables for single dimension or when we have multidimensional databaes

Is This Answer Correct ?    0 Yes 0 No

when we go for snow flake schema rather than star schema ?..

Answer / divya

Snow flake schema is used when there are hierarchies,where
as star schema is used when there is only one level and no
hierachies

Is This Answer Correct ?    1 Yes 2 No

when we go for snow flake schema rather than star schema ?..

Answer / bo_fan

Star schema : fact table with dimension tables around.
Snow flake schema: fact table with dimension tables around
and the dimension tables again have sub tables to it.
Example: When we have a scenario like student table and
subject details table (which is a sub table of student table)
There we can go for snow flake schema(going more details ie
normalization)

Is This Answer Correct ?    1 Yes 4 No

Post New Answer

More Business Objects Interview Questions

How many universes will run maximum in single project

1 Answers   HP,

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

0 Answers   ASD Lab, Wipro,

can BO generate reports with out CUBICAL data to repository?

4 Answers  

Explain which versions are used in the bo dashboard work?

0 Answers  

What is metrics?

2 Answers  




HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers  

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,

Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,

what is custom sorting?how we can do this expalain with procedure???

2 Answers   Keane India Ltd,

What is the strategies ? what is the need of the strategies?

2 Answers   IBM,

What are the difference between merge,auto merge and extended merge ?

1 Answers   Cap Gemini,

What is Cartesian product?

14 Answers  

For more Business Objects Interview Questions Click Here
Categories