Answer / 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.

Answer / subhash

Join is used to link to tables depending upon the data
requested by the user, Usually we have Inner Join, Outer
Join, Left Join, Right Join, Full Outer join.

Answer / vams_gk

join is very imp concept in BO

relation between two tables is called joins.
we have 4 types of join relations 1:m,m:1,m:m,1:1

types of joins in BO
1)equi join
2)theta join
3)outer join(left/right)
4)isolated join
5)short cut join

Answer / venkatesh

Hi everybody,

whatever NareshKumar explained about the joins is right
except the Shortcut join.

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.

In the above defination (which is mentioned in the inverted
commas)the result wont be same. It is different.

Example:
There is 4 tables
A,B,C,D

The join in between these 4 tables are like this.

A--B--C--D

Here if I drag A and D tables then I will get 6 rows for
example.

Now Make a shortcut join between A and D

Now if I drag A and D tables then I will get more than 6
rows.Why because

In first join the data is filtering from A to D like below
First A to B then B to C after that C to D.

But in Shortcut there is direct join A to D.Here the data
is not filtering.

Thanks,
Venky

Answer / srinu

Combining a data from multiple tables is called join.
There r 5 types of joins r there.
1)Simple join 2)Equi join 3)Outer join 4)Theta join
5)Short cut join

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

0 Answers  

---

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

Can any body Explain me what are the critical problems you have faced in the designer and repoting level in the real time environment?

2 Answers  

---

what is the difference b/w star and snowflack schema in dataware house?

8 Answers  

---

---

Explain in Detail about Measure Objects? and what is the use of it? How to create it?

5 Answers  

---

what is xcelsius architecture?

0 Answers   Zensar,

---

Explain about a tricky situation for which you found a very simple solution?

0 Answers  

---

Any body help me...what are challenges did u face in Business object project?

1 Answers  

---

I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

what is Scope of Analysis

8 Answers   TCS,

---