Interested to Buy Any Domain ? << Click Here >> for more details...
What is shortcut join?could give any one example?
- 8 Answers
- 25156 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 |
Can we use unconnected lookup as dynamic lookup?
What is package in BO
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Can any please explain FOR EACH AND FOR ALL?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
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 is the difference between datawarehousing and businessintelligence?
How to sheduling the report ? What is the need of it?
In a column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?
what is the difference between Ranking and sort-out in bo?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
Teradata 
