by using expression transformation U can apply decode function..

following table

source

name gender

a1 male
a2 female

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

Question Posted / koti

Answer Posted / koti

by using expression transformation U can apply decode
function..

Is This Answer Correct ?

9 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are 3 tech challenges/ common issues you face?

2346

What are roles and groups and benefits of using them?

1057

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1132

Define mapping and session?

1033

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8222

State the limitations where we cannot use joiner in the mapping pipeline?

1065

What is the advantage of informatica?

1069

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

Write the program through which the records can be updated?

1004

What are different types of transformations available in informatica?

991

What are the features of complex mapping?

1156

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1124

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

How you prepared reports for OLAP?

1595

What is aggregate cache in aggregator transformation?

1145