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


Please Help Members By Posting Answers For Below Questions

what is size of u r database?

1865


How would you join a node to the already existing domain?

696


What is domain in terms of informatica?

578


how to load dimension table and fact table. plz tell me the steps.

1696


If informatica has its scheduler why using third party scheduler?

798






Write the program through which the records can be updated?

528


What are the new features of Power Center 5.0?

1247


Explain incremental aggregation in informatica

663


difference between informatica 8.1.1 and 8.6

3260


What are the new features of informatica 9.x in developer level?

576


What are junk dimensions?

643


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1478


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1668


Explain informatica architecture - version 8 / 9

681


What is Index Caches size?

633