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

How we can add a comment in universe...?

1 Answers  


Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,


How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,


HOW TO HIDE Column in WEBI & DESKI?

6 Answers  


Difference between zabo and webi?

0 Answers  


when we go for snow flake schema rather than star schema ?

5 Answers   TCS,


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

1 Answers  


can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,


What is the difference between business requirement document and use case document.

0 Answers  


What is the use of BO SDK?

5 Answers  


Aliases and Contexts Which once will give the better performence when resolve the loops?

3 Answers   HCL,


What are the differences between webi and deski of XI R2 not the earlier versions

1 Answers  


Categories