using query SELECT 'JAN' AS MONTHS,SUM(JAN) FROM CALADERQUERY

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 / dilip ingole

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

Answer Posted / dilip ingole

using query

SELECT 'JAN' AS MONTHS,SUM(JAN) FROM CALADERQUERY
UNION
SELECT 'FEB' AS MONTHS,SUM(FEB) FROM CALADERQUERY
UNION
SELECT 'MAR' AS MONTHS,SUM(MAR) FROM CALADERQUERY
UNION
SELECT 'APR' AS MONTHS,SUM(APR) FROM CALADERQUERY;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

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

1712

Define update strategy?

1214

Briefly describe lookup transformation?

1042

In development project what is the process to follow for an etl developer from day1

1714

Why do you use Mapping Parameter and mapping variable?

1757

What is mapping debugger?

1007

What is primary and backup node?

1123

Where do we use mapping variables in informatica?

1061

How to update source definition?

1082

What is the difference between router and filter?

1259

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2153

how to load dimension table and fact table. plz tell me the steps.

2091

what is the difference between informatica6.1 and infomatica7.1

2268

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1631

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10676