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 / amitabha mandal
use "Normalizer"
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What do you mean by blocking transformation?
What are the different components of powercenter?
Can we get 1st record through Informatica(without sequence number).
What are batches?
What are the various types of transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Why sorter is an active transformation?
Why is sorter an active transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
can we override a native sql query within informatica? Where do we do it?
What are the reusable transformations?
lookup transformation with screenshots
In warehouses how many schemas are there?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY