After draging the ports of three sources(sql
server,oracle,informix) to a single source qualifier, can
you map these three ports directly to target?
Answers were Sorted based on User's Feedback
Answer / kanth
Here they are having Heterogeneous sources how can those
can be joined at source quaifier.i think the question is
not clear u cannot darg the three heterogeneous siurces to
sinle source qualifier
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / atiric software(raja)
we cannot join haterogeneous sources in the s.q so we
cannot map those ports to target directly if we want we must
use the joiner transformation
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / bidhar
You cannot join Hetrogeneous sources in a SQ.For that you
need use joiner.For example if you have n hetrogeneous
sources then you must use n-1 joiners.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / madhukar
We cant perform heterogeneous sources with sqt.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swetha
NO.Unless and until u join those three ports in source
qualifier you cannot map them directly.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / eric yang
To Swetha,
I am afraid these 3 ports have been joined already in source
qualifier, and therefore can map directly to a target, why not?
| Is This Answer Correct ? | 1 Yes | 2 No |
What are events in workflow manager?
how did u understand business requirement?
How many mapplets u have created? and what is the logic used
why we r using presql&postsql in source qualifier?
How can you generate reports in informatica?
what is upstream and downstream transformation?
can anyone explain me about retail domain project in informatica?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
How can we delete duplicate rows from flat files?
Enlist few areas or real-time situations where informatica is required.
How to join three sources using joiner?
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?