In my job,reading data from a dataset, using an aggregator to get min 'account_no', doing some lookup to derive a value and joined this value to the main dataset data and out puts to a dataset .
in this job to improve the performance i used hash partition in the join to perform stable sort.
iam getting the following warnings
![Question :?:](./images/smilies/icon_question.gif)
In join stage: "When checking operator: Operator of type "APT_TSortOperator": will partition despite the
preserve-partitioning flag on the data set on input port 0."
In aggrigator stage: "When binding output interface field "MIN_ACCOUNT_NO" to field "MIN_ACCOUNT_NO": Implicit conversion from source type "dfloat" to result type "decimal[20,0]": Possible range/precision limitation."
Note: in aggrigator the field "MIN_ACCOUNT_NO" id derived field base on "ACCOUNT_NO" field.
Can anybody please help me avoid the above warnings.
Thanks in anticipation.