Answer Posted / vidya
Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.
Theta join Link tables based on a relationship other than
equality between two columns.
| Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
What is the functional & architectural differences between business objects and web intelligence reports?
How we drill up week to month?
Is there any other repository domains rather than universe, security, document?
How many universes can be created in a project?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
What is the difference between user and versatile user?
8. How much supervision have you typically received in your previous job?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Explain about a time when you discovered a more efficient way to do a work task?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What is a fantrap in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
