How do you Join tables from different Oracle Databases ?

2 tables are present on 2 oracle databases, How to join those 2 tables? Which transformation should be used?

Showing Answers 1 - 6 of 6 Answers


  • Dec 27th, 2006


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

  Was this answer useful?  Yes

vami krishna.K

  • Dec 29th, 2006

The both tables need to be join using joiner only.

  Was this answer useful?  Yes


  • 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)

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes


  • 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions