Wrong Results in Aggregator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
Wrong Results in Aggregator
Hi,
In my input data i have amount coloumn as data type Decimal(15,2).
the amount may contain either +'ve or -'ve values.
When I am trying to sum up the amount coloumn using aggregator first it raised up warning saying precesion exceeding.
so that i have changed the data type from decimal to double before aggregator.then it is not showing up any warnings.
but on each time i run the job the aggregated amount coloumn is showing wrong results.
I even used Modify stage also before aggregator but still it is showing wrong resuts.
test data.
ID AMOUNT(15,2)
10 150.00
10 -100.00
10 -50.00
20 140
30 45
30 -45
so after aggregation it should come like this without any warnings.
ID AMOUNT(15,2)
10 0
20 140
30 0
Please help.
In my input data i have amount coloumn as data type Decimal(15,2).
the amount may contain either +'ve or -'ve values.
When I am trying to sum up the amount coloumn using aggregator first it raised up warning saying precesion exceeding.
so that i have changed the data type from decimal to double before aggregator.then it is not showing up any warnings.
but on each time i run the job the aggregated amount coloumn is showing wrong results.
I even used Modify stage also before aggregator but still it is showing wrong resuts.
test data.
ID AMOUNT(15,2)
10 150.00
10 -100.00
10 -50.00
20 140
30 45
30 -45
so after aggregation it should come like this without any warnings.
ID AMOUNT(15,2)
10 0
20 140
30 0
Please help.
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
RE:Wrong Results in Aggregator
For each run i am getting different values like as follows
ID AMOUNT(15,2)
10 150
20 140
30 0
or
ID AMOUNT(15,2)
10 -150
20 140
30 -45
ID AMOUNT(15,2)
10 150
20 140
30 0
or
ID AMOUNT(15,2)
10 -150
20 140
30 -45
OddJob wrote:What values did you actually receive?
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 20
- Joined: Fri Oct 14, 2005 12:52 am
-
- Participant
- Posts: 11
- Joined: Mon Mar 17, 2008 3:14 pm
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague