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
server hot-ws270 is connect to Repository B. What does it mean?
What are the advantages of informatica?
How to update a particular record in target with out running whole workflow?
What is standalone command task?
What are the differences between joiner transformation and source qualifier transformation?
What are the types of caches in lookup?
What is a shortcut and copy in Informatica and how two are different with each other?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Mention some types of transformation?
What is target designer and target load order?
Explain sql transformation in script mode examples in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is option by which we can run all the sessions in a batch simultaneously?
What is the maplet?
What is Session and Batches?