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 is domain and gateway node?
What is a passive transformation?
How to create or import flat file definition in to the warehouse designer?
What can we do to improve the performance of informatica aggregator transformation?
Define update strategy?
What is resilience time?
What is enterprise data warehousing?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the function of aggregator transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How do you update the records with or without using update strategy?
What could be the possible resons of locks by user?
What are Dimensional table?
What is the benefit of partitioning a session?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?