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
What are the features of complex mapping?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is dimensional table? Explain the different dimensions.
What is flashback table ? Advance thanks
Separate from a database, an information bazaar, and an information stockroom?
What is decode in informatica?
Describe an informatica powercenter?
What is a node in Informatica?
What is workflow manager?
Partition, what happens if the specified key range is shorter and longer
Briefly define reusable transformation?
What are roles and groups and benefits of using them?
In warehouses how many schemas are there?
Make a note of the quantity vaults made in informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?