following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
Answer Posted / abhishek kumar
src->sq->exp->filter->tgt
expression t/f
flag ->
iif(gender='male','female','male')
abhishek guddu
Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
Partition, what happens if the specified key range is shorter and longer
What is sq transformation?
If informatica has its scheduler why using third party scheduler?
Explain lookup transformation source types in informatica
Explain the tuning lookup transformation - informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Differentiate between sessions and batches?
What is the sql query overwrite in source qualifier in informatica
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the settings that you use to configure the joiner transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is a shortcut and copy in Informatica and how two are different with each other?
On which transformations you created partitions in your project?
Define joiner transformation?