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

What is the pragma?

2 Answers  


Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

1 Answers   HCL,


1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  


what is diff between webi,deski,infoview

2 Answers  


4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,






When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

0 Answers  


What is domain? How many are there in a basic setup? What are they?

1 Answers  


if i hv 2 reports in one block... first report contains ten rows and second report contains 100 rows. my question is ....if i want to enter the values into first report(i want more than ten rows in first report)..is it possible to get ..

1 Answers   TCS,


IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,


why we use aggregation in lower level

1 Answers   TCS,


How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?

1 Answers   TCS,


Categories