HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Answers were Sorted based on User's Feedback
Answer / vidya
Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.
Theta join Link tables based on a relationship other than
equality between two columns.
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / vams_gk
shortcut join :it is direct join between source and
destination
example :country-->region--.city
we can coneect country and city using shortcut join
theta join :non equality condition between two tables
| Is This Answer Correct ? | 6 Yes | 6 No |
How we can add a comment in universe...?
Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu
How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?
HOW TO HIDE Column in WEBI & DESKI?
Difference between zabo and webi?
when we go for snow flake schema rather than star schema ?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
can we create aliases for every table beforehand? if yes whar are the disadvantages?
What is the difference between business requirement document and use case document.
What is the use of BO SDK?
Aliases and Contexts Which once will give the better performence when resolve the loops?
What are the differences between webi and deski of XI R2 not the earlier versions