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


Please Help Members By Posting Answers For Below Questions

server hot-ws270 is connect to Repository B. What does it mean?

1858


What are the advantages of informatica?

576


How to update a particular record in target with out running whole workflow?

1161


What is standalone command task?

713


What are the differences between joiner transformation and source qualifier transformation?

628






What are the types of caches in lookup?

575


What is a shortcut and copy in Informatica and how two are different with each other?

688


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?

1241


Mention some types of transformation?

607


What is target designer and target load order?

660


Explain sql transformation in script mode examples in informatica

606


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1789


What is option by which we can run all the sessions in a batch simultaneously?

667


What is the maplet?

622


What is Session and Batches?

666