After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can u map these three ports directly to target?

NO.Unless and until u join those three ports in source qualifier u cannot map them directly.

Interview Candidate
Sep 21st, 2004
4
4741

Showing Answers 1 - 4 of 4 Answers

rishi

Dec 14th, 2005

if u drag three hetrogenous sources and populated to target without any join means you are entertaining Carteisn product. If you don't use join means not only diffrent sources but homegeous sources are show same error.
If you are not interested to use joins at source qualifier level u can add some joins sepratly.

Rajesh

Dec 19th, 2005

Yes, it possible...

Vani_AT
Profile Answers by Vani_AT

Apr 2nd, 2008

I don't think dragging three heterogeneous sources in a single source qualifier is valid.
Whenever we drag multiple sources in same source qualifier,
1. There must be a joining key between the tables.
2. The SQL needs to be executed in the database to join the three tables.

To use a single source qualifier for multiple sources, the data source for all the sources should be same.
For Heterogeneous join, a Joiner transformation has to be used.
The first part of the question itself is not possible.

prade
Profile Answers by prade Questions by prade

Jun 26th, 2008

Sources from heterogenous databases cannot be pulled into a single source qualifier. They can only be joined using a joiner. And then can be written to the target