Warring while finding Max, Min Date - Aggregator Stage

[K.A.R.PAULSON]

In a job I am trying to find out the maximum and minimum date from the given date field. For that I was made a job with Aggregator stage.
I am getting the required out put, but I am getting multiple warring in the log file. The warring message I am listed below.

Acc005_Aggr_MaxMinDate_TopAcc..Aggr_MaxMin_Date: At row 1991, link "Input_Agg", while processing column "Output_Agg.MIN_FIRST_SHIP_DATE"
Value treated as NULL
Attempt to convert String value "" to Long type unsuccessful


Please let me know how to handle this warring.

Thanks and regards
Regi

[arunverma]

Hi ,

I have succesfully developed This type of Job , pl. find step i used .

For Ex. sequential file File contain empid , join_date , leaving_date

1. date value as DD-MON-YYYY , column format VarChar2(13)
2. Sort this file using CO-Sort Plug in - empid asc none no N
3. use aggregator to get max min .
In aggregator output stage are
3.1 mark empid as Key and Group
3.2 derivation for min_join_date = MIN(join_date) ,
min_join_date = MIN(leaving_date )

My job is working fine .

[arunverma]

Sorry , one point I have missed out , before sorting file pl ensuere
that derived column should not NULL , to avoid this type of problem
use constraint as Not(IsNull(ToTransf.join_date) .