Hi all
Is anyone came across the following warnings:
1. AGGR_SUMAMT: When checking operator: When binding output interface field "TMMBR_ADJ_A" to field "TMMBR_ADJ_A": Implicit conversion; from source type "dfloat" to result type "decimal[9,2]": Possible range/precision limitation
I think the above error comes when i try to introduce a new column (calculated)in my stage
2. AGGR_Cash,0: Hash table has grown to 16384 entries.
I have to fix the above warnings...
Thanks
Madhav.
Aggregator Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Tue Jul 13, 2004 5:26 am
- Location: chennai
- Contact:
Hi Madhva,
for your warning
" AGGR_Cash,0: Hash table has grown to 16384 entries"
try following thnigs
In the aggregator stage properties change the method from hash to sort. The reason for this is given below
Use hash mode for a relatively small number of groups; generally, fewer than about 1000 groups per megabyte of memory. Sort mode requires the input data set to have been partition sorted with all of the grouping keys specified as hashing and sorting keys.
for your warning
" AGGR_Cash,0: Hash table has grown to 16384 entries"
try following thnigs
In the aggregator stage properties change the method from hash to sort. The reason for this is given below
Use hash mode for a relatively small number of groups; generally, fewer than about 1000 groups per megabyte of memory. Sort mode requires the input data set to have been partition sorted with all of the grouping keys specified as hashing and sorting keys.
-
- Premium Member
- Posts: 141
- Joined: Tue Mar 16, 2004 8:22 am
- Location: HSBC - UK and India
- Contact:
Hi,
This option only available for Calculation, but not for Row Count.
Any other option can be set to solve the warning for Row Count ?
Thanks
This option only available for Calculation, but not for Row Count.
Any other option can be set to solve the warning for Row Count ?
Thanks
lakshmipriya wrote:In aggregator stage the default output data type is dfloat, you can convert the datatype to decimal by adding the "Available sub prodperity to add" has the "Decimal Output" option
Just check with that one, which will solve your first query as i suppose
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I doubt that it's the same message for RowCount - which is never, could never, be a decimal number with more than zero decimal places.
Read the message carefully; it tells you what you've asked it to convert, and warns you about why it may be infeasible.
Read the message carefully; it tells you what you've asked it to convert, and warns you about why it may be infeasible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.