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
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain your project of banking domian.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
expain about the tune parameters?
How do we call shell scripts from informatica?
how many types of dimensions are available in informatica?
Do you find any difficulty while working with flat files as source and target?
What are the popular informatica products?
In development project what is the process to follow for an etl developer from day1
How to load the data from a flat file into the target where the source flat file name changes daily?
How can we use batches?
What are the new features of informatica 9.x in developer level?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N