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 |
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
Example of how the fantraps and chasm traps works?
How to create universe in business objects enterprise 11.5
in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
how to hide the prompts?
why we use aggregation in lower level
what is universe testing(not mention check integrity)
5.what is LOV? where it is store?
What is the difference between user and versatile user?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
What happens in BO when a user logs in to Infoview and a rich client like webi?
WHAT IS SAP BO AND BO?