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 is the function of aggregator transformation?

1071

How you prepared reports for OLAP?

1586

Separate from an archive server and a powerhouse?

947

Explain the different lookup methods used in informatica?

1025

What is the command used to run a batch?

1052

In how many ways we can create ports?

1111

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2306

What are mapplets? How is it different from a Reusable Transformation?

1075

how to create user defined function (udf) in informatica

1290

what is INFORMATICA TESTING process

2280

Define joiner transformation?

1031

Suppose we do not group by on any ports of the aggregator what will be the output?

1033

without table how to come first record only in oracle?

2240

What are the tuning techniques you applied during your last project

2018

what is degenerated dimension?

3965