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 a router transformation?
What do you mean incremental aggregation?
difference between informatica 8.1.1 and 8.6
can we override a native sql query within informatica? How do we do it?
What do you mean by enterprise data warehousing?
waht type of interface is used for testing the data in informatica
Have you worked with/created Parameter file
What is sequence generator transformation in informatica?
How to extract the informatica rejected data?
What is union transformation in informatica?
What are the features of complex mapping?
Enlist the tasks for which source qualifier transformation is used.
How can you define user defied event?
What is InformaticaPowerCenter?
what is the -ve test case in your project.