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
What is mapping debugger?
What are the new features of Power Center 5.0?
what is $$$$?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is dynamic cache?
Implementation methodology
Mention few advantages of router transformation over filter transformation.
Make a note of the quantity vaults made in informatica?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain constraint based loading in informatica
Is it possible to create multiple domains on a single Informatica server?
What will be the approach?
How to create or import flat file definition in to the warehouse designer?
What is a repository? And how to add it in an informatica client?
How to call shell scripts from informatica?