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 |
How will you convert rows into columns or columns into rows
What are the different types of Type2 dimension maping?
Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
How can informatica be used for an organization?
What are the two modes of datamovement in informatica sever?
how to join two flat files in informatica?
Tell me about informatica architecture.
normalizer transformation
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)