when we go for snow flake schema rather than star schema ?
- 5 Answers
- 10646 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
How would you format some text using css to be verdana and bold?
How to generate the report from excel sheet?
Explain about a task that really tested your analytical abilities?
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...
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain what is the difference between business requirement document and use case document.
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What three things do you consider to be the most important factors for a manager?
how to create metric universe ?
What is top business?
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,
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)?
When to use local filter and when to use global filter?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
