following table source name gender

following table

source

name gender

a1 male
a2 female

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

Question Posted / sujith

2 Answers
5611 Views
I also Faced
E-Mail Answers

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

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers Cap Gemini,

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers CTS,

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers

What all join we can perform in LOOKUP transformation?

0 Answers

What is depict expression change?

0 Answers

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers

What is the need of an ETL tool?

0 Answers Informatica,

Explain the types of transformations?

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