How will you display "Mr" for male & "Mrs" for female in
target table?
Answer Posted / giri
Use Expression Transformation
Add new Field
Condition
IIf(fieldname='male','Mr','Mis')
This field Check Variable then
add newfield Concat(newfield,first name)
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are the differences between source qualifier and joiner transformation?
Explain the informatica workflow?
While migrating the data from one environment to another environment how would you manage the connections?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the components of Informatica? And what is the purpose of each?
What does update strategy mean, and what are the different option of it?
Explain in detail scd type 2 through mapping.
What is the surrogate key?
How to start a workflow using pmcmd command?
How many number of sessions can one group in batches?
What is workflow manager?
Enlist the advantages of informatica.
What is the sequence generator transformation in informatica?
What are active and passive transformations?
what is size of u r database?