we can't sum aggregate function in Exp T/F.i.e it is not possible to

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 / sham

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

Answer Posted / sham

we can't sum aggregate function in Exp T/F.i.e it is not
possible to use sum() in expression T/F. so go through Agg T/F
....

Group by month
o/p port-------> sum(sal)

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

What is decode in static cache?

1181

Define mapplet?

1013

What is a surrogate key?

1083

Is it possible to revert a global repository to local one and why?

1081

What is an unconnected transformation?

1087

How do you change a non-reusable transformation to reusable transformation?

999

How to load data in informatica ?

1022

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

draw informatica architecture 8.6 ?

3873

What all join we can perform in LOOKUP transformation?

978

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

permutations of mapplet

2511

Describe the impact of several join conditions and join order in a joiner transformation?

1063

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1322