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 are the join problems comes appart from loop,chasm & fan Traps
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
how to prepare the documentation in business objects and where to get the requirement?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
U r project in which stage in implementation?
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)?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is the difference in creating filters in designer and business objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is aggregate table and aggregate fact table ... Any examples of both?
Which versions are used in the bo dashboard work?