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

shobha

  • Dec 27th, 2006
 

Hi,

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

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)

  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

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

  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.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions