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
Answers were Sorted based on User's Feedback
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 |
Answer / triveni
i have one doubt.how to convert source to columns using sourcequalifier. how many columns target we have take.
how to connect source to target
source has 4 columns
target has 2 columns
Is This Answer Correct ? | 0 Yes | 0 No |
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
What are the parts of Informatica Server?
What is the Difference between SetVariable and setmaxvariable in informatica?
What is facttable granularity?
Differentiate between router and filter transformation?
can we use mapplet as starting n ending object in mapping
Different circumstance which drives informatica server to expel records?
Can we create out put ports in source qualifier t/r?
What is the difference between Normal load and Bulk load?
How does a sorter cache works?
What is status code?
To provide support for Mainframes source data,which files r used as a COBOL files