if we have input eno 1,2,3,1,2,3 year
2001,2002,2003,2001,2002,2003 and sal
10000,20000,30000,20000,30000,40000
ex-output
eno totsal
1 30000
2 50000
3 70000
- 7 Answers
- 7746 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit kansal
In Aggregator Transformation Create an output Port name TOTSAL, And in front of eno port check group by and in TOTSAL column use SUM(sal)
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the informatica workflow?
How can we improve session performance in aggregator transformation?
What are the different transaction levels available in transaction control transformation?
What are the types of caches in lookup? Explain them.
How to improve the performance of a session using sorter transformation?
Why is sorter an active transformation?
Can you generate sequence numbers without using the sequence generator transformation?
What is pmcmd command?
How can you increase the performance in joiner transformation?
What is dimensional table?
What does role playing dimension mean?
my source is junk data how will u remove that junk data by using unix please any one replay me
What do mean by local and global repository?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explian the Process of deployment groups in informatica
