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 the meaning of up gradation of repository?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Implementation methodology
Mention some types of transformation?
What are the different components of powercenter?
How we can create indexes after completing the loan process?
Write the prerequisite tasks to achieve the session partition?
What is the use of source qualifier?
What is confirmed fact in dataware housing?
How to delete duplicate row using informatica?
What is a transaction control transformation?
Separate from an archive server and a powerhouse?
what is the difference between informatica6.1 and infomatica7.1
waht type of interface is used for testing the data in informatica
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.