Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

Answers were Sorted based on User's Feedback



HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?..

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

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?..

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

Post New Answer

More Business Objects Interview Questions

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

1 Answers  


Example of how the fantraps and chasm traps works?

1 Answers   IBM,


How to create universe in business objects enterprise 11.5

1 Answers  


in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level

3 Answers   Accenture,


how to hide the prompts?

7 Answers   TCS,


why we use aggregation in lower level

1 Answers   TCS,


what is universe testing(not mention check integrity)

1 Answers  


5.what is LOV? where it is store?

3 Answers   TCS,


What is the difference between user and versatile user?

0 Answers  


Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,


What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,


WHAT IS SAP BO AND BO?

1 Answers  


Categories