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 / 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


Please Help Members By Posting Answers For Below Questions

What are the differences between source qualifier and joiner transformation?

1071


Explain the informatica workflow?

1081


While migrating the data from one environment to another environment how would you manage the connections?

1099


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1067


What are the components of Informatica? And what is the purpose of each?

1064


What does update strategy mean, and what are the different option of it?

1102


Explain in detail scd type 2 through mapping.

1052


What is the surrogate key?

1276


How to start a workflow using pmcmd command?

1261


How many number of sessions can one group in batches?

1170


What is workflow manager?

1060


Enlist the advantages of informatica.

1075


What is the sequence generator transformation in informatica?

1191


What are active and passive transformations?

1094


what is size of u r database?

2319