You will take Expression Transfermation. In Expression Editon you can writ

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 / chandra mouli

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

Answer Posted / chandra mouli

You will take Expression Transfermation.
In Expression Editon you can write lke this
sum(months) and group by month.

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to convert multiple rows to single row (multiple columns) in informatica

1319

How to create Target definition for flat files?

1159

What is lookup change?

989

What are the uses of etl tools?

1068

wat are deployement groups in informatica, how it will be used for developers

1670

Explain in detail scd type 2 through mapping.

991

what are the Methods For Creating Reusable Transformations?

1102

Please let me know how to make Data masking in informatica..

1665

Implementation methodology

1657

Define pmcmd command?

994

without table how to come first record only in oracle?

2207

What is fact table? Explain the different kinds of facts.

1012

Explain pushdown optimization and types in informatica

1018

how many types of dimensions are available in informatica?

1001

Difference between Data and Index Caches?

1096