following source
name gender
ramya female
ram male
deesha female
david male
kumar male
i want the target
male female
ram ramya
david deesha
kumar
any body give solution above question?
- 8 Answers
- 10359 Views
- BRAD, TCS, I also Faced
- E-Mail Answers
Answer Posted / jaspreet banga
after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by active and passive transformation?
What are the different transaction levels available in transaction control transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Do you find any difficulty while working with flat files as source and target?
What are the popular informatica products?
While migrating the data from one environment to another environment how would you manage the connections?
What is Cognos script editor?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
what is SDLC way of code development?
In informatica workflow manager, how many repositories can be created?
What are connected or unconnected transformations?
How do you load unique records into one target table and duplicate records into a different target table?
What is the reusable transformation?
What is a transaction control transformation?
Explain the difference between mapping parameter and mapping variable?
