GeekInterview.com
Series: Subject: Topic:
Question: 565 of 1133

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?
Asked by: Interview Candidate | Asked on: Dec 23rd, 2006
Showing Answers 1 - 6 of 6 Answers
shobha

Answered On : Dec 27th, 2006

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

  
Login to rate this answer.
vami krishna.K

Answered On : Dec 29th, 2006

The both tables need to be join using joiner only.

  
Login to rate this answer.
Aravind

Answered On : 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)

  
Login to rate this answer.

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

  
Login to rate this answer.

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.

  
Login to rate this answer.
RAMESHKUMARREDDY

Answered On : 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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.