Informatica - 2 tables are present on 2 oracle databases, How to join those 2 tables? Which transformtion should b

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 120 of 303

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

Total Answers and Comments: 6

Last Update: February 18, 2007 Asked by: mahendra

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 27, 2006 04:32:01

shobha

RE: 2 tables are present on 2 oracle databases, How to...

Hi,

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

Is this answer useful? Yes | No

December 29, 2006 08:51:47

vami krishna.K

RE: 2 tables are present on 2 oracle databases, How to...

The both tables need to be join using joiner only.

Is this answer useful? Yes | No

January 02, 2007 06:13:48

Aravind

by using J.T & S.Q.T

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)

Is this answer useful? Yes | No

January 12, 2007 07:04:14

manjunathda

Member Since: January 2007 Contribution: 5

RE: 2 tables are present on 2 oracle databases, How to...

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

Is this answer useful? Yes | No

February 07, 2007 23:48:41

akmohanty

Member Since: December 2006 Contribution: 17

RE: 2 tables are present on 2 oracle databases, How to...

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.

Is this answer useful? Yes | No

February 18, 2007 14:46:12

RAMESHKUMARREDDY

RE: 2 tables are present on 2 oracle databases, How to...

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

Is this answer useful? Yes | No

Go To Top