Interested to Buy Any Domain ? << Click Here >> for more details...
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
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....
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
How to schedule the report in b.o?
What Is Snow Flake Schema?
What task is 98% of the required work of a business analyst?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
how to prepare the documentation in business objects and where to get the requirement?
Difference between b.o 5.1 and 6.1b?
Is there any other repository domains rather than universe, security, document?
Explain about a task that really tested your analytical abilities?
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
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
How can you first report in Business Objects by using broadcast agent?
How to generate the report from excel sheet?
