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 sequence generator transformation in informatica?

1074


What is domain in terms of informatica?

1005


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2335


How to elaborate tracing level?

1172


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

1237


What is a transaction control transformation?

1204


What is the need of etl tools?

1115


Is it possible to define a single node as a Gateway node as well as worker node?

1121


What are active transformations.

1651


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2069


hi real timers . iam waiting for ur reply regarding ETL TESTING

2267


What is a difference between complete, stop and abort?

1078


How to join three sources using joiner? Explain though mapping flow.

1144


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2258


What are multi-group transformations?

1093