Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9326 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
can u any challenge your project?
Define pmcmd command?
What are the new features of Power Center 5.0?
Enlist the advantages of informatica.
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
How to improve the performance of a session using sorter transformation?
What is informatica etl tool?
What is the difference between stop and abort in informatica
Difference between Data and Index Caches?
differences between service based and product based?
How are the sources and targets definitions imported in informatica designer?
Mention a few design and development best practices for informatica?
How do you set a varible in incremental aggregation
Can anyone tell me the new features in Informatica 9 Version?
How to differentiate between the active and passive transformations?
