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 the difference between union and group?
What would you consider as your biggest achievement and why?
What is Indexing? how did u implement indexing?
What is difference between custom hierarchy and report based hierarchy?
how to create reports on screech?
Explain what three things do you consider to be the most important factors for a manager?
Difference between b.o 5.1 and 6.1b?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is package in BO
How to generate the report from excel sheet?
Explain about a task that really tested your analytical abilities?
What is the difference between slice and dice and cross tab report?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
8. How much supervision have you typically received in your previous job?
Explain about a time when you discovered a more efficient way to do a work task?