Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the meaning of up gradation of repository?

2055


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

2170


Implementation methodology

1773


Mention some types of transformation?

1097


What are the different components of powercenter?

1114


How we can create indexes after completing the loan process?

1252


Write the prerequisite tasks to achieve the session partition?

1230


What is the use of source qualifier?

1186


What is confirmed fact in dataware housing?

7107


How to delete duplicate row using informatica?

1090


What is a transaction control transformation?

1264


Separate from an archive server and a powerhouse?

1011


what is the difference between informatica6.1 and infomatica7.1

2362


waht type of interface is used for testing the data in informatica

2300


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2116