Interested to Buy Any Domain ? << Click Here >> for more details...
What is shortcut join?could give any one example?
- 8 Answers
- 25361 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 |
what is data cubes??
Can we Save (save as) WEBI Doc as DESKI?
What is the pivot option ? what is the need of it?
Can we configure two instances of CMS pointing to two different CMS system databases?
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two?
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
What are the difference between merge,auto merge and extended merge ?
Teradata 
