Answer Posted / nareshkumar
A join is a condition that links the data in seperate but
related tables. The tables usually have a parent-child
relationship. If a query does not contain a join, the
database returns a result set that contains all possible
combinations of the rows in the query tables.
Types of joins:
1) Equi-Joins
Link tables based on the equality between the values in the
column of one table and the values in the column of another.
2) Theta Joins
Link tables based on a relationship other than equality
between two columns.
3) Outer Joins (Left Outer, Right Outer, Full Outer)
Link two tables, one of which has rows that do not match
those in the common column of the other table.
4) Shortcut Joins
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.
5) Self restricting joins
Single table join used to set a restriction on the table.
Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
what will be the contents for a functional requirements specifications
Explain when we use aggregate awareness function in designer?
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
Can more than 1 metric be applied on an analytic in business objects?
What task is 98% of the required work of a business analyst?
What is top business?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is thumbnail?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is the dense rank?
What Is Snow Flake Schema?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye