magpie

• Sep 30th, 2005

 

joins two tables without a join key. Key should be {}.

sithusithu

 Profile Answers by sithusithu 

• Jan 30th, 2006

 

A Cartesian join will get you a Cartesian product. A Cartesian join is when you join every row of one table to every row of another table. You can also get one by joining every row of a table to every row of itself.

Cheers,

Sithu

anupsadhwani60

 Profile Answers by anupsadhwani60 

• Sep 16th, 2007

 

For Hibernate, Cartesian joins are used in combination with where clause in theta style joins.

This is useful when you don't have foreign keys defined for 2 tables, and you still want to query them using hql.


 

surabhiraghu

 Profile Answers by surabhiraghu Questions by surabhiraghu

• Jan 3rd, 2008

 

 join two tables without join key , that is crossproduct.

PeeD1

 Profile Answers by PeeD1 

• Apr 16th, 2009

 

When there are duplicate keys in either or all of the joined datasets the result is a cartesion product. This is termed as Cartesian Join in Abinitio.
Eg:
If there are two input datasets for a join function on a perticular key and that 1st dataset has 2 records for a particular key value and 2nd dataset has 3 records for that key vakue than the output will have 2*3=6 records for that key value.

Null Key [ {} ] will result in N*M records
where N = No of records in dataset 1
and M = No of records in dataset 2