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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
which one is better performance wise joiner or look up
Define joiner transformation?
How can one identify whether mapping is correct or not without connecting session?
How can you increase the performance in joiner transformation?
Enlist the various types of transformations.
What is the benefit of session partitioning?
How many ways are there to create ports?
Partition, what happens if the specified key range is shorter and longer
What are the types of caches in lookup?
Name the different lookup cache(s)?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me 5 session failure in real time how can you solve that in your project?
What's the layout of parameter file (what does a parameter file contain?)?
In informatica workflow manager, how many repositories can be created?