following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
- 2 Answers
- 4901 Views
- I also Faced
- E-Mail Answers
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 an Integration service in Informatica?
What is meant by incremental aggregation?
What is the function of union transformation?
What is pmcmd command?
What are active and passive transformations?
What is the sequence generator transformation in informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How do you load unique records into one target table and duplicate records into a different target table?
what is informatica metadata?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What does reusable transformation mean?
How to extract sap data using informatica? What is abap? What are idocs?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the types of schemas we have in data warehouse.
