HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

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

593


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.

1877


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

1611


What we need to discuss with designer before starting the universe designing.

1814


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1487






How to create Index to the table in the universe designer and how it improves the Query performence

2111


Explain how to schedule the report in b.o?

557


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

684


what will be the contents for a functional requirements specifications

1777


Explain in detail about type 1?

645


How we drill up week to month?

613


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

1809


U r project in which stage in implementation?

1944


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4176


Explain the difference between union and group?

618