shobha

• Dec 27th, 2006

 

Hi,

We can use Joiner transformation if tables having atleast one matching column.

vami krishna.K

• Dec 29th, 2006

 

The both tables need to be join using joiner only.

Aravind

• Jan 2nd, 2007

 

Both the tables are from Same database only,So one colum must be same in Both the tables to join AND we can use JoinerTransformation as well as SourceQualifierTransformation to join those two tables(we can use SourceQualifierTransformation if both tables from same database)

manjunathda

 Profile Answers by manjunathda Questions by manjunathda

• Jan 12th, 2007

 

if the table are from the same database then we can use look up,soure quilifier and joiner transformation.

if the tables are from heterogenous database then we use joiner transformation. we can join one flat file and one relational table in joiner transformation

akmohanty

 Profile Answers by akmohanty Questions by akmohanty

• Feb 7th, 2007

 

Import these two tables from source one by one. Then drag to source screen.Then by the common field of both the tables just drag from one table to another table.

RAMESHKUMARREDDY

• Feb 18th, 2007

 

hi these two tables are coming from different oracle data bases we can use joiner transformatin to join them if there if is no relation we can join based on datatypes