Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 11982 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / smiley
When we have multiple tables for single dimension or when we have multidimensional databaes
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
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 |
What is the slice and dice?
What task is 98% of the required work of a business analyst?
normally we get many contexts when resolving loops or traps,how do u take them to reports.
is there any limit for rows and columns in cross tab
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?
Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks
How to change font color of values in hyperlinked columns?
What is the difference between Sychronisatio and join?
Can Bo generates the Report from the cubical data Explain?
How to implement LDAP authentication in BOE
how get the grand total in master-detail report?
how do you give security to universe ?
2 Answers InfoStep, Tech Mahindra,
Teradata 
