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

how to restrict null values in webi report?

2 Answers   InfoStep,


i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me

0 Answers  


Hi friends How to design Xcelsius dashboard trough "SAP Netweaver connection" please explain steps for SAP Net weaver connection.

1 Answers  


How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers  


What is the use of AFD? Where it can be stored?

1 Answers  






How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.

1 Answers   Cap Gemini, TCS,


how to overcome overflow of data in a report

6 Answers  


whats the diff between break and section

4 Answers   TCS,


Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  


u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources

4 Answers   IBM,


How we drill up week to month?

0 Answers  


Draw the architecture of traps?

3 Answers   Wipro,


Categories