Interested to Buy Any Domain ? << Click Here >> for more details...
How will you display "Mr" for male & "Mrs" for female in
target table?
- 7 Answers
- 13122 Views
- I also Faced
- E-Mail Answers
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 is the function of look up transformation?
How can we use batches?
what is informatica metadata?
Enlist the differences between database and data warehouse.
What are different types of transformations available in informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain the scenario which compels informatica server to reject files?
How can one identify whether mapping is correct or not without connecting session?
What is the difference between Active and Passive transformation?
What are the different versions of informatica?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain the difference between mapping parameter and mapping variable?
Describe an informatica powercenter?
What are the guidelines to be followed while using union transformation?
Explain the mapping variable usage example in informatica
