Interested to Buy Any Domain ? << Click Here >> for more details...
following table
source
name gender
a1 male
a2 female
how to change 'male' to 'female' and 'female' to 'male'
- 2 Answers
- 5605 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
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is lookup change?
What are the features of complex mapping?
Please let me know how to make encryption and decryption with example?
How to go to the older version for a mapping?
What are the new features of Power Center 5.0?
What is the difference between stop and abort in informatica
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What is an Integration service in Informatica?
Separate from a database, an information bazaar, and an information stockroom?
Can you use flat files in Mapplets.
What is a snowflake schema?
How to load data in informatica ?
How to generate sequence numbers using expression transformation?
