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 / chinthi

actually i need total as new record value as 10000

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain where to store informatica rejected data? How to extract the informatica rejected data?

574


What do you mean by filter transformation?

549


permutations of mapplet

2034


What differs when we choose the sorted input for aggregator transformation?

567


What are mapplets? How is it different from a Reusable Transformation?

622






How to open an older version of an object in the workspace?

614


What are ETL Tools?

662


Differentiate between Load Manager and DTM?

1661


What is the scenario which compels informatica server to reject files?

599


What are the different clients of powercenter?

592


Which is the t/r that builts only single cache memory?

706


How many ways are there to do 'remove duplicate records in informatica'?

583


What is the benefit of session partitioning?

589


What are the differences between oltp and olap?

546


How we can create indexes after completing the loan process?

725