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

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mapping debugger?

1016


What are the new features of Power Center 5.0?

1779


what is $$$$?

2160


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2747


What is dynamic cache?

1036


Implementation methodology

1714


Mention few advantages of router transformation over filter transformation.

1023


Make a note of the quantity vaults made in informatica?

988


Can informatica load heterogeneous targets from heterogeneous sources?

1187


Explain constraint based loading in informatica

1096


Is it possible to create multiple domains on a single Informatica server?

1242


What will be the approach?

979


How to create or import flat file definition in to the warehouse designer?

1070


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

1149


How to call shell scripts from informatica?

999