when we go for snow flake schema rather than star schema ?
Answer Posted / 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 |
Post New Answer View All Answers
What is top business?
What are the steps to be taken to schedule the report?
What is difference between webi and infoview?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are the join problems comes appart from loop,chasm & fan Traps
Explain about alerts in bos, under what situation we need to use alerts?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
Give some information on report bursting?
how to prepare the documentation in business objects and where to get the requirement?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY