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
7690 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

which one is better performance wise joiner or look up

1025

Global and Local shortcuts. Advantages.

1957

What is source qualifier transformation in informatica?

947

Can we get 1st record through Informatica(without sequence number).

1406

How do you take back up of repository?

1094

How to join three sources using joiner?

1029

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1028

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

2206

How to generate sequence numbers without using the sequence generator transformation?

1113

wf dont have integration severances how you can run?

1883

What is a sequence generator transformation?

951

what is unit testing?tell me proceedure

2165

What is the meaning of decode in informatica?

1073

how to load dimension table and fact table. plz tell me the steps.

2036

what is diff b/t sorter t/r and agg have the option sorter property...

2129