Explain about Short cut join?

Question Posted / vinod3035

2 Answers
6023 Views
Wipro, I also Faced
E-Mail Answers

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

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers

I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?

3 Answers BirlaSoft,

what are the all possible reasons of getting partial result on a webi report?

3 Answers L&T,

Explain is there any default username & pwd for bo designer & supervisor?

0 Answers

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers Exilant, Wipro,

What is the difference between the Bo 3.0 and 3.1?

1 Answers

How many universes will run maximum in single project

1 Answers HP,

WHAT ARE THE VARIOUS PRODUCTS IN BO?