How will you display "Mr" for male & "Mrs" for female in
target table?

Answer Posted / madhusudhana reddy

decode(gender,male,'Mr',Female,'Mrs,optional)

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways are there to do 'remove duplicate records in informatica'?

574


What is the session task and command task?

588


How to use procedural logic inside infromatica?

626


How many ways are there to create ports?

713


What are the data movement modes in informatica?

688






What is the benefit of session partitioning?

585


what is INFORMATICA TESTING process

1830


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1617


Define pmcmd command?

613


Explain how to import oracle sequence into informatica?

581


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

1739


How to update or delete the rows in a target, which do not have key fields?

643


How do you change a non-reusable transformation to reusable transformation?

586


What is informatica? Why do we need it?

625


What is the sequence generator transformation in informatica?

604