you will take Expression transfermation and write expression like this

Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Question Posted / chandu621

8 Answers
11063 Views
HP, I also Faced
E-Mail Answers

Answer Posted / chandu621

you will take Expression transfermation
and write expression like this

sum(months)

Is This Answer Correct ?

0 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2120

What is transformation?

1099

What is a filter transformation?

1043

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1081

How many types of sessions are there in informatica.please explain them?

1165

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7240

What are the different types of transformation available in informatica.

1105

Target increases every day even though no new record was inserted

1580

How can a transformation be made reusable?

1167

What do you mean incremental aggregation?

1076

What are the mapping parameters and mapping variables?

1204

What are the static cache and dynamic cache in informatica?

1192

COM components can be used in Informatica

2390

Differentiate between source qualifier and filter transformation?

1578