Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 12147 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 are the diffrences between Business Objects 5.1 & 6.5 ?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
. User wants to modify a report and wants to add additional data. How will you approach.
i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance
HOW TO SPOT A HIERARCHY?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
What is sdlc in bo?
when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
Aliases and Contexts Which once will give the better performence when resolve the loops?
HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?
Teradata 
