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

Explain the features of connected and unconnected lookup.

929

Which is the t/r that builts only single cache memory?

1185

What is intricate mapping?

1197

How to use pmcmd utility command?

1026

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

2169

What are multi-group transformations?

1088

What are the mapping parameters and mapping variables?

1198

How to implement security measures using repository manager?

1173

Have you worked with/created Parameter file

1660

what is informatica metadata?

1031

What is the reusable transformation?

1045

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7442

Explain sessions?

1050

Explain the tuning lookup transformation - informatica

988

How to Create a folder using pmrep command?

1173