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

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

0 Answers  


Is it mandatory to give a cardinality ? If cardinality is not given what will happen?

4 Answers   Infotech,


6.what is conformed dimension? R u used?

8 Answers   TCS,


IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,


WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash

2 Answers   BirlaSoft,






how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?

1 Answers   Accenture, TCS,


1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,


WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,


How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,


How to hide the table s in webi?can any one tell me plzzzzzzzz

9 Answers   Accenture, TCS,


What is the link option in the reporting Environment?

3 Answers  


how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers   Keane India Ltd,


Categories