Explain about Short cut join?
Answers were Sorted based on User's Feedback
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 |
hi,
to detect joins automatically go to insert-joins-detect joins..
Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between slice and dice and cross tab report?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
6.what is conformed dimension? R u used?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
WHAT ARE THE INDEXES THAT SUPPORT DATA WAREHOUSING ? Thanks In advance Prakash
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI
How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?
How to hide the table s in webi?can any one tell me plzzzzzzzz
What is the link option in the reporting Environment?
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