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 is the function of aggregator transformation?
Quickly characterize reusable change?
Explain the difference between mapping parameter and mapping variable?
What is informatica worklet?
generate date / time dimension in informatica
What is sq transformation?
How does the aggregator transformation handle null values?
What all are steps in up gradation of Informatica server?
How do you take back up of repository?
How to convert multiple rows to single row (multiple columns) in informatica
What is the maplet?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is meant by active and passive transformation?
Explain joiner transformation in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?