use normalizer trans,then give condition input 5,output 1 as accurs 5,resu

source
file name xyz

a,0,a,a,a
b,b,b,0,b
c,c,c,0,c

target should be like this

xyz
a
b
c

how to implement this?

Question Posted / rajesh

Answer Posted / rajesh

use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can we create multiple integration service on single repository?

1240

What is informatica powercenter repository?

1254

How do you take back up of repository?

1206

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1146

whats the logic to load the lower level of granularity of data to fact table.

2309

What is substr in informatica?

1259

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1331

How can a transformation be made reusable?

1223

What is transformation?

1157

How can informatica be used for an organization?

1271

Explain scd type 3 through mapping.

1051

Briefly explain the aggregator transformation?

1063

What does command task mean?

1214

can you please explain me pre session and post session options?

7666

How do you change a non-reusable transformation to reusable transformation?

1046