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 many ways can we implement SCD2?

4 Answers   IBM, TCS,

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

0 Answers  

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

Scheduling properties,whats the default (sequential)

0 Answers  

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

Why the workflow is failed after running two hours in informatica?

1 Answers   GE,

How can you complete unrcoverable sessions?

1 Answers  

what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,

What is complex mapping?

0 Answers  

Define pmcmd command?

0 Answers  

For more Informatica Interview Questions Click Here
Categories