Aliases and Contexts Which once will give the better
performence when resolve the loops?
Answer Posted / vasanth
alias is used when two dim tables and one fact table are there in the loop ,alias is used for one dim table which has less outer joins.
Context are used when there are 2 fact tables and one dim table in the loop,we create context for one join between one fact and dim in the loop.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain in detail about type 1?
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?
Explain 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)?
Explain is data mart?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
How to generate the report from excel sheet?
can anybody tell me about complicated object you have created
What are the join problems comes appart from loop,chasm & fan Traps
How to schedule the report in b.o?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What would you consider as your biggest achievement and why?
What is thumbnail?
Difference between zabo and webi?
what are the tables used in health care domain project and columns used in report?