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

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 tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  


how to create reports on screech?

0 Answers   Zensar,


What is the use of BO SDK?

5 Answers  


WHAT KIND OF TOOL BO IS?

7 Answers  


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  






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 ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,


How can we acheive Correlated sub-query in Designer?

2 Answers   Infosys, TCCX, Wells Fargo,


Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com

2 Answers  


What is the difference between condition & filter?

0 Answers  


what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,


I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,


Categories