aggregator problem
Posted: Mon Sep 20, 2010 9:06 am
Hi Every one ,
1. I used some stages to develop the job. I am having a problem with the aggregator stage as when i perform the function 'Sum' in aggregator stage,
I am getting an error saying that invalid argument type. When I use with any other functions in aggregator stage, it is working.
The process of the job is as follows: I am grouping two fields and I have to sum based on the grouping fields. I know this is not a typical job but I am not sure why i am getting an error only with the Sum function in aggregator stage. I also checked with different Data types like Varchar, Integer, Long Varchar but still not working. Can any one suggest me what is the solution for this error?
Thanks in advance
1. I used some stages to develop the job. I am having a problem with the aggregator stage as when i perform the function 'Sum' in aggregator stage,
I am getting an error saying that invalid argument type. When I use with any other functions in aggregator stage, it is working.
The process of the job is as follows: I am grouping two fields and I have to sum based on the grouping fields. I know this is not a typical job but I am not sure why i am getting an error only with the Sum function in aggregator stage. I also checked with different Data types like Varchar, Integer, Long Varchar but still not working. Can any one suggest me what is the solution for this error?
Thanks in advance