In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male
in my output i need
male,female
vasu,geetha
ram,suma
kesav
Answer Posted / srinivas.medagum
When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG
I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA
CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a grid in Informatica?
What is a dimensional model?
What are the uses of etl tools?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is mapping debugger?
How are the sources and targets definitions imported in informatica designer?
What is the commit type if you have a transaction control transformation in the mapping?
Differentiate between router and filter transformation?
How can you generate reports in informatica?
How you prepared reports for OLAP?
Briefly describe lookup transformation?
What is transformation?
How to partition the Session?
What is joiner transformation in informatica?
What is an expression transformation?