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


following table


source

name gender

a1 male
a2 female


how to change 'male' to 'female' and 'female' to 'male'

Answers were Sorted based on User's Feedback



following table source name gender a1 male ..

Answer / koti

by using expression transformation U can apply decode
function..

Is This Answer Correct ?    9 Yes 0 No

following table source name gender a1 male ..

Answer / abhishek kumar

src->sq->exp->filter->tgt
expression t/f

flag ->
iif(gender='male','female','male')



abhishek guddu

Is This Answer Correct ?    7 Yes 2 No

Post New Answer

More Informatica Interview Questions

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


What is operational data source (ODS)?

7 Answers  


In informatica workflow manager, how many repositories can be created?

0 Answers  


How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


what is bridge tables in informatica

1 Answers   CTS,


explain abt union t/r?

1 Answers   IBM,


Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  


how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,


Categories