Hi, Using UNION ALL ,You can achieve it, here is Your Query SELECT '

write sql query following source table

jan feb mar apr
100 200 300 400
500 600 700 800
900 100 200 300
i want the output format like

month total
jan 1500
feb 900
mar 1200
apr 1500

Question Posted / chanakya123

3 Answers
8361 Views
Accenture, I also Faced
E-Mail Answers

Answer Posted / chanakya123

Hi, Using UNION ALL ,You can achieve it, here is Your Query

SELECT 'JAN' AS MONTH, SUM(JAN) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'FEB' AS MONTH, SUM(FEB) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'MAR' AS MONTH, SUM(MAR) AS TOTAL FROM SRC_MONTHS
UNION ALL
SELECT 'APR' AS MONTH, SUM(APR) AS TOTAL FROM SRC_MONTHS

Thanks
Kalyan Sankuthula

Is This Answer Correct ?

23 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does “tail –f” command do and what is its use as an Informatica admin.

1034

What is an aggregator transformation?

1032

How to Create a folder using pmrep command?

1107

differences between service based and product based?

1973

In how many ways we can create ports?

1069

How many numbers of sessions can one group in batches?

1017

What are the guidelines to be followed while using union transformation?

1068

What are the advantages of informatica?

961

 Informatica Checkpoints

3273

Which is the t/r that builts only single cache memory?

1130

What is union transformation?

911

What are the different options available for update strategy?

946

To import the flat file definition into the designer where should the flat file be placed?

1012

Explain the mapping variable usage example in informatica

1090

How big was your fact table

1750