Use Normalizer t/r, it convert column into rows,row into columns.

i want to convert below src into target

src is as follows
maths 30
science 20
social 81

i want data in trg like below

maths science social
30 20 81

Question Posted / amedela chandra sekhar

2 Answers
7796 Views
HCL, HP, I also Faced
E-Mail Answers

Answer Posted / amedela chandra sekhar

Use Normalizer t/r, it convert column into rows,row into
columns.

Is This Answer Correct ?

2 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can we override a native sql query within informatica? Where do we do it?

1100

How can you increase the performance in joiner transformation?

1181

What are the different versions of informatica?

1247

lookup transformation with screenshots

3985

What is rank transformation in informatica

1152

What is a predefined event?

1082

As union transformation gives UNION ALL output, how you will get the UNION output?

1087

complex mapping ur project u r invlve can u explain and give real time example give me ?

2273

Where are the source flat files kept before running the session?

1058

How can we use mapping variables in informatica? Where do we use them?

1168

How are indexes created after completing the load process?

1622

What is meant by pre and post session shell command?

1139

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2047

What are the informatica performance improvement tips

1069

Is it possible to create multiple domains on a single Informatica server?

1220