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
How can you increase the performance in joiner transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is domain in terms of informatica?
What are the static cache and dynamic cache in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is pmcmd command?
Define pmcmd command?
What is the cumulative sum and moving sum?
What is a snowflake schema?
How to configure mapping in informatica?
What are connected or unconnected transformations?
What is the benefit of session partitioning?
How can you generate reports in informatica?
What are the designer tools for creating transformations?
Can we create two repositories on same database instance in oracle?