Interested to Buy Any Domain ? << Click Here >> for more details...
What is shortcut join?could give any one example?
- 8 Answers
- 25264 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 the aggrigate navigation ? can anybody explain me with some practical example?
CAN ANY BODY TELL WHAT FUTURE CAREER IN BUSINESS OBJECTS?
What is Designer?
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process
Can you please send me the migration related issues .
what is isolated joins in check integrity
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
it is possible to link two universes of separate functional domain ?
What are the general issues in migration process?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is aggregate table and aggregate fact table ... Any examples of both?
can anybody tell me how many classes where there and objects in each class
Teradata 
