max

• May 15th, 2006

 

without common fields or ports in two diffrent tables, its not possible to join two tables.its need atleast one common field or port to join two diffrent tables.

venkat

• Jun 8th, 2006

 

hi,

without common column or common data type we can join two sources using dummy ports.

1.Add one dummy port in two sources.

2.In the expression trans assing '1' to each port.

2.Use Joiner transformation to join the sources using dummy port(use join conditions).

hope this will help.

Regards

Venkat

kumar

• Jun 11th, 2006

 

could you please briefly explain on this?

Prasad

• Jul 14th, 2006

 

what ever is said above is correct. Just add 2 dummy ports in the joiner transformation with the same datatypes(Integer). one dummy port as detail and other as master.Then assign both the ports default values as 1, i guess u know that how to assign a default value. Then use these 2 ports in the join condition. It ensures that all the records are matched and basically it will be a cartician product.In oracle it is same as a select query without a where clause.