Explain about Short cut join?

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


Please Help Members By Posting Answers For Below Questions

What three things do you consider to be the most important factors for a manager?

604


How many universes can be created in a project?

599


what is document design in boxi,have u participate in that

1663


What is the difference between slice and dice and cross tab report?

608


What are the join problems comes appart from loop,chasm & fan Traps

1557






What is difference between custom hierarchy and report based hierarchy?

554


How to restrict password to a user while sending a document in .pdf format

1866


Differences between business objects and web intelligence reports?

659


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....

1492


Explain what sort of existing documents should business analysts refer to when starting on a new project?

608


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?

9883


Difference between b.o 5.1 and 6.1b?

654


Explain how we drill up week to month?

644


Explain what task is 98% of the required work of a business analyst?

605


8. How much supervision have you typically received in your previous job?

1837