Answer Posted / anu
A shortcut join is a join that provides alternate path
between two tables.Shortcut joins improve the performance
of a query by not taking into account intermediate tables,
and so shortening a normally longer join.
A common use of shortcut joins is to link a shared lookup
table to another table further along a join path. The join
path comprises several different tables in the same
context. In such a case, the shortcut join is only
effective when the value being looked up has been
denormalized to lower levels in a hierarchy of tables, so
the same value exists at all the levels being joined.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What three things do you consider to be the most important factors for a manager?
How many universes can be created in a project?
what is document design in boxi,have u participate in that
What is the difference between slice and dice and cross tab report?
What are the join problems comes appart from loop,chasm & fan Traps
What is difference between custom hierarchy and report based hierarchy?
How to restrict password to a user while sending a document in .pdf format
Differences between business objects and web intelligence reports?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Difference between b.o 5.1 and 6.1b?
Explain how we drill up week to month?
Explain what task is 98% of the required work of a business analyst?
8. How much supervision have you typically received in your previous job?