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
When we use aggregate awareness function in designer?
Did you face any problems while creating reports? Name? Solutions?
What is the difference between the public object&schema object?
any difficulitis have you phase while creating bo reports and how did u solve it
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
Explain is there any default username & pwd for bo designer & supervisor?
Explain how we drill up week to month?
Can we create universe with no cache??
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 would you consider as your biggest achievement and why?
Can anybody tell me what are the tuning problems?
In banking domain how many Fact tables,Dimension table are present?
can anybody tell me about complicated object you have created
How to open a universe with out using the Designer ??
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.