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

what is the hint? how to use it to reduce the query processing in program?

7982

Can you generate sequence numbers without using the sequence generator transformation?

1163

How can you define user defied event?

1076

What is dimensional table?

1133

What are the types of data warehouses?

1577

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847

What is the meaning of up gradation of repository?

2055

permutations of mapplet

2550

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8265

Explain the different dimensions.

1009

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1180

What do you understand by term role-playing dimension?

1118

Describe expression transformation?

1170

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2579

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1100