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

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers   Patni,


If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


What are the joiner caches?

3 Answers   Informatica,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  


i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,


Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,


How can repository reports be accessed without sql or other transformations?

0 Answers  


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,


What are conformed dimensions?

1 Answers  


In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,


explain about informatica server architecture?

1 Answers   IBM,


Categories