When we are going for Shortcut join and why.
Answer Posted / pvraobo@gmail.com
Shortcut join is a join that provides an alternative path between two tables.shortcut join improve the performance of a query by not taking into account intermediate tables.
Note:This is only used per improving the report performance.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Explain is data mart?
What would you consider as your biggest achievement and why?
How to generate the report from excel sheet?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain is there any default username & pwd for bo designer & supervisor?
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?
What is top business?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain how to schedule the report in b.o?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain what three things do you consider to be the most important factors for a manager?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is difference between webi and infoview?
What are the steps to be taken to schedule the report?