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
Warring while finding Max, Min Date - Aggregator Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Sun Aug 01, 2004 2:33 am
- Location: Dubai
- Contact:
Re: Warring while finding Max, Min Date - Aggregator Stage
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 .
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 .
Arun Verma
Re: Warring while finding Max, Min Date - Aggregator Stage
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) .
that derived column should not NULL , to avoid this type of problem
use constraint as Not(IsNull(ToTransf.join_date) .
Arun Verma