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 |
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
what is diffrence b/w joner and union transfermation
how to load dimension table and fact table. plz tell me the steps.
.prm wirh repalce .txt is possible?
difference between shortcut and reusable transformation?
"Change cache" in Informatica ?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
All active transformations r passive or not?
What is the target load order?