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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

1057


Can Bo generates the Report from the cubical data Explain?

2087


Explain what is aggregate table and aggregate fact table ... Any examples of both?

1153


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2197


Explain how many universes can be created in a project?

1113


What is difference between webi and infoview?

1327


What are the join problems comes appart from loop,chasm & fan Traps

2188


How would you format some text using css to be verdana and bold?

1121


Explain about alerts in bos, under what situation we need to use alerts?

1101


in sap bi we have wad, then why we go for sap bo

3428


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10517


What is a fantrap in business objects?

1228


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1099


How can you first report in Business Objects by using broadcast agent?

3106


Explain how to execute the plsql procedure from the report by clicking with mouse?

1101