What is shortcut join?could give any one example?
- 8 Answers
- 23733 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s.kumanan
By pass the intermediate tables and give the altenate path
between the two tables is called shortcut join.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / v.sivakumar
To make it simple short cut joins are used to reduce the
joins in the Query which will increase the performance of
the query
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / vijay
Join provinding an alternative path between 2 tables ,by
passing intermediate table ,leading to the same
result.regardless of direction
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / sourabh gosain
Short cut join is a join between 2 tables to improve query
performance. if one face table can be connected to other
fact table to retrieve data, but we are not able to join
that table due to looping problem, then we can connect them
through short cut join. that way join remains invisible for
integrity check. Hence data when selected from 2 tables
comes fast as there is no intermediate table to join them.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sweety
we can have more number of shortcut joins if we change the universe parameter shortcut behavior from successive to global
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / abhishek
hi all,
Basically the shortcut or smart join are special type of
join by which we can reduce the complexcity of report and
avoid loop like
T1 key1
T2 key2
T3 key3
then in universe there t2 is fac table and t1 an t2
are lookup table then if we want some data frm t3 table by
the foraigan key T1 to T3 then if we creat a simply join
then that is make a loop and aslo that join search the huge
fac table aslo so there is new smart or shortcut join by
which we can join t1 to t3 its show in dotted line in
univeres designer and does not create and loop
| Is This Answer Correct ? | 4 Yes | 7 No |
Answer / ashish bhojane
We can have ONLY ONE shortcut join in an Universe.
| Is This Answer Correct ? | 3 Yes | 6 No |
hi,
The joins are two types... the first one is equi-join that
is using of = symbol.for example we have two tables called
wmp and dept. in emp we have deptno object. the same object
we have dept table also then we can create like this:
emp.deptno = dept.deptno.
The non-equijoin is with out same object from the both table
by using between keyword. we can take the bellow example
like emp(empno,sal) and salgrade(grade, lesssal,highsal) we
can create join from the aboue table like this: where sal
between lesssal and highsal.
| Is This Answer Correct ? | 1 Yes | 6 No |
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
what is difference between folders and category ?
hi my question is in a report table how can we write table header without using of individual cell.can we merge column cells togrther??
What are the Users and User groups?
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
How to create predefined filters in B.O.
I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data
What is top business?
Explain is there any default username & pwd for bo designer & supervisor?
What is the definition of derived table ?
what is static filter and dynamic filter
Teradata 
