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 is the difference between user and versatile user?

585


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

606


what are the day to day activities of BO administrator ?

1980


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

1586






How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1892


Explain what sort of existing documents should business analysts refer to when starting on a new project?

607


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2607


Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

4450


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1582


What are the data types present in bo? What happens if we implement view in the designer and report?

622


Difference between b.o 5.1 and 6.1b?

653


Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1628


Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

593


How many universes can be created in a project?

599