Page 1 of 1
Percentage based rejectiontion handling
Posted: Sun Sep 30, 2007 6:44 am
by baba
Hi all,
Can any body help me to know, How to handle if rejects are 40% during validation( ie validation based on Null,Duplicates,PK) , JOB sappose to be Aborted automatically and same record has to be sent to Client through Email
Sceranio: Simple Job Source to Staging 1
Types of Jobs used: Sequential file to Transformer to Oracle Stage
Thanks
Baba
Posted: Sun Sep 30, 2007 7:51 am
by chulett
Welcome Aboard. :D
That's something you'll need to code in yourself and depending on when you enforce the %, you may need to know the total number of record you will be processing as well.
Do you 'need' to stop things immediately when it hits 40%? Pass the total in as a parameter and check as you go via a Constraint. Not sure how easily you could make that work for a multi-node job, however.
Rather then abort a running job (never really a good idea) why not check after the validation and not proceed onwards instead? An 'after' check would be easier to arrange - get total and reject counts in a Sequence job, compare the two and decide what to next.
Food for thought...
thanks Craig , i will try
Posted: Wed Oct 03, 2007 8:39 am
by baba
chulett wrote:Welcome Aboard. :D
That's something you'll need to code in yourself and depending on when you enforce the %, you may need to know the total number of record you will be processing as well.
Do you 'need' to stop things immediately when it hits 40%? Pass the total in as a parameter and check as you go via a Constraint. Not sure how easily you could make that work for a multi-node job, however.
Rather then abort a running job (never really a good idea) why not check after the validation and not proceed onwards instead? An 'after' check would be easier to arrange - get total and reject counts in a Sequence job, compare the two and decide what to next.
Food for thought...