How can we get two output ports in un-connect transformation?
Answers were Sorted based on User's Feedback
Answer / prabhu
You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 9 Yes | 0 No |
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
without update strategy how to insert &update?
What is the difference between normal and bulk loading? Which one is recommended?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
What is a mapplet/worklet in informatica?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
Explain direct and indirect flat file loading (source file type) - informatica
What are the different options available for update strategy?
can we use mapplet as starting n ending object in mapping
What do think which one is the better joiner or look up?
How to start a workflow using pmcmd command?