Interested to Buy Any Domain ? << Click Here >> for more details...
when we go for snow flake schema rather than star schema ?
- 5 Answers
- 12140 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
What is the difference between condition & filter?
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.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
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 there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can we Save (save as) WEBI Doc as DESKI?
What is report template in b.o?
how get the grand total in master-detail report?
8. How much supervision have you typically received in your previous job?
Difference between b.o 5.1 and 6.1b?
Explain about a tricky situation for which you found a very simple solution?
Explain is data mart?
what are the day to day activities of BO administrator ?
