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

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1048

Have you worked with/created Parameter file

1614

What is a predefined event?

1037

what is unit testing?tell me proceedure

2168

How to use pmcmd utility command?

972

Explain lookup transformation source types in informatica

1042

What is native users?

1102

Difference between Data and Index Caches?

1096

How to generate or load values in to the target table based on a column value using informatica etl tool.

1019

What is a repository manager?

1029

Can we change Dynamic to Static or Persistent cache? If so what happens?

2152

What are batches?

1010

What is the use of code page?

1013

What are the types of data warehouses?

1430

differences between service based and product based?

1973