source
name sal
aaaa 2000
bbbb 3000
abcd 5000
Target
name sal
aaaa 2000
bbbb 3000
abcd 5000
total 10000
how to get total as new row and sum as 10000
thanks
Answer Posted / babu
Hi Chinthi
You will do the above mapping,definely you can get
whatever you want.
Please check and intimate in case of any issues.
dwarak.vbr@gmail.com
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
What are the popular informatica products?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How you can differentiate between connected lookup and unconnected lookup?
What is workflow manager?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is Index Caches size?
What are the modules in Power Center
What are the advantages of informatica?
What if the source is a flat-file?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the benefit of session partitioning?
What is the use of source qualifier?
what is diff b/t sorter t/r and agg have the option sorter property...
How to update a particular record in target with out running whole workflow?