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 domain? How many are there in a basic setup? What are they?

1 Answers  


how u restrict the values?to display 5 values insted of 10 values?

4 Answers  


What is security domain in Business Objects?

4 Answers   Polaris,


In a Webi Report, Once u r entering a month name,it displays the that month details and after and before month details.How it is

3 Answers   Wipro,


1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,






What are the data types present in bo? What happens if we implement view in the designer and report?

0 Answers  


which is the best way to resolve loop context r alias why?

3 Answers  


How many tables can an universe contain is their any limit to insert tables in the universe?

3 Answers  


How can you access your repository with different user profiles?

2 Answers   TCS,


how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,


What is the pivot option ? what is the need of it?

1 Answers   Infotech,


What is the difference between absolute and relative div positioning?

0 Answers  


Categories