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 is size of u r database?
How would you join a node to the already existing domain?
What is domain in terms of informatica?
how to load dimension table and fact table. plz tell me the steps.
If informatica has its scheduler why using third party scheduler?
Write the program through which the records can be updated?
What are the new features of Power Center 5.0?
Explain incremental aggregation in informatica
difference between informatica 8.1.1 and 8.6
What are the new features of informatica 9.x in developer level?
What are junk dimensions?
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 .
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Explain informatica architecture - version 8 / 9
What is Index Caches size?