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
Explain when we use aggregate awareness function in designer?
How would you format some text using css to be verdana and bold?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How were the reports scheduled and how to resolve unexecuted documents?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain in detail about type 1?
Explain what are the measure objects?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain what are the steps to do to use alerts in bo?
What Is The Difference Between Oltp And Olap?
How many universes can be created in a project?
When we use aggregate awareness function in designer?
What is the difference in creating filters in designer and business objects?
