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 / shiva bansal
use router and expr1 for male and expr2 for female
combine them in expression transformation and connect the
expression to target
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is informatica?
Explain what transformation and how many are there in informatica?
What are the new features of informatica 9.x developer?
Can you generate sequence numbers without using the sequence generator transformation?
Briefly describe lookup transformation?
What is the sequence generator transformation in informatica?
Explain the different dimensions.
How to load last n records of file into target table - informatica
What is the commit type if you have a transaction control transformation in the mapping?
How do you take back up of repository?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Design a mapping to load a target table with the following values from the above source?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a stored procedure transformation?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance