when we go for snow flake schema rather than star schema ?
- 5 Answers
- 10246 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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
How to schedule the report in b.o?
What are all difference between business objects 6.5 and xi r2?
What Is Snow Flake Schema?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is the difference between business requirement document and use case document.
Explain is there any other repository domains rather than universe, security, document?
Did you face any problems while creating reports? Name? Solutions?
Explain about alerts in bos, under what situation we need to use alerts?
When we use aggregate awareness function in designer?
what are the day to day activities of BO administrator ?
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 to open a universe with out using the Designer ??
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
