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
Explain joiner transformation in informatica
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the popular informatica products?
How big was your fact table
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Design a mapping to load a target table with the following values from the above source?
Explain in detail about scd type 1 through mapping.
Explain the types of transformations?
What is the difference between source qualifier transformations source filter to filter transformation?
have u done any performance tuning? how u ll do?
What is the cumulative sum and moving sum?
What is the difference between informatica 7.0 and 8.0?
Different sorts of metadata that stores in the storage facility?
explain one complex mapping with logic? sales project?