Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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 / dinesh

Answers were Sorted based on User's Feedback



write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

Answer / 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

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

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

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700..

Answer / amitabha mandal

use "Normalizer"

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Informatica Interview Questions

How to implement security measures using repository manager?

0 Answers  

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

How can you join two tables without any common column present in them?

1 Answers   TCS,

What is a rank transform?

0 Answers  

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

What are the different types of repositories created using informatica?

0 Answers  

As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,

what are the perameter and variable?

3 Answers   IBM,

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

What is the use of target designer?

0 Answers  

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories