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?
Answer Posted / 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 |
Post New Answer View All Answers
How can a transformation be made reusable?
What are Dimensional table?
What is meant by lookup transformation?
What is intricate mapping?
Explain the use of aggregator cache file?
What can we do to improve the performance of informatica aggregator transformation?
How to delete duplicate row using informatica?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can we override a native sql query within informatica?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
can you please explain me pre session and post session options?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
without table how to come first record only in oracle?
What is the use of source qualifier?