How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / narinder
Assuming that the source data has some kind of identifier
to track male or female record then use the decode function
based on idetifier to store 'Mr' or 'Mrs' in a port in an
expression transformation and pass this port value to
target.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can use union transformation?
How many types of sessions are there in informatica.please explain them?
Quickly characterize reusable change?
Slowly changing dimensions, types and where will you use them
Performance tuning in UNIX for informatica mappings?
design of staging area?
Write the unconnected lookup syntax and how to return more than one column.
What all join we can perform in LOOKUP transformation?
can anyone explain me about retail domain project in informatica?
What is an active transformation?
What are the limitations of joiner transformation?
Define filter transformation?
Please let me know how to make Data masking in informatica..
explan ur project architecture?
What is informatica metadata and where is it stored?