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

How we can use union transformation?

1102

What is lookup change?

1108

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170

What do you mean by filter transformation?

1003

Whats there in global repository

1737

How can you generate reports in informatica?

1081

What is workflow? What are the components of the workflow manager?

1169

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2310

What is the Process to creating lookup transformation in informatica

1090

What are the main issues while working with flat files as source and as targets ?

1216

Why do we need informatica?

1054

Can we override a native sql query within informatica?

1087

What is lookup transformation?

1092

What is a connected transformation?

1183

r u done any partitions in ur project?

1862