Explain about Short cut join?

Answers were Sorted based on User's Feedback



Explain about Short cut join?..

Answer / 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

Explain about Short cut join?..

Answer / rajasekhar

hi,
to detect joins automatically go to insert-joins-detect joins..

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Business Objects Interview Questions

Explain what would you consider as your biggest achievement and why?

0 Answers  


what is incompactabulity error in sap bo

2 Answers  


1.what is context? How u create? With example.

2 Answers   Polaris, TCS,


I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

3 Answers   IBM,


why measure objects are semantically dynamic?

1 Answers  






Hi , iam beginer in the Boxi . I am getting errors when i applying the @promtps and functions. I want alredy created universe and i absorve the things how those were applied . is it possible to get it throug internet? if it is possible could u plz help me? anandh1110@gmail.com

2 Answers  


can i use stored procedure in webi?

4 Answers   CTS, Wipro,


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,


What is shortcut join?could give any one example?

8 Answers  


When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,


what is diff between webi,deski,infoview

2 Answers  


What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 Answers  


Categories