Abort a job when data in a link has reached some threshold

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 3:04 am

Hi,

Is there a possibility to abort a job when the data in a particular link (say error link) has reached a threshold (i.e, 30% of the Input count - assuming the input count is available as a job parameter)

Any help/suggestions are highly appreciated.

Thanks,
DSUser7.

ArndW · Post by **ArndW** » Sat Nov 29, 2008 5:24 am

Yes, look at your Transform stage and the setting for "Abort after rows"

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 6:14 am

ArndW wrote:Yes, look at your Transform stage and the setting for "Abort after rows" ...

But AndrW, the setting- Abort after rows will take only numerals...I mean I wouldn't be able to use a parameter there. But as the count of records in the input file is dynamic, I wouldn't be able to hardcode the 30% of the count.
Is there any other way to do it?
Please suggest
Thanks

ArndW · Post by **ArndW** » Sat Nov 29, 2008 6:41 am

If you only have a percentage as input then you cannot do this from within the job unless you know how many rows you are going to get. Then you can compute the trigger number of rows and make a reject link output force the job to abort when the constraint send a row down that link.

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 7:08 am

ArndW wrote:If you only have a percentage as input then you cannot do this from within the job unless you know how many rows you are going to get. Then you can compute the trigger number of rows and make a reject ...

Sorry, but I couldn't view your complete response as it was 'Premium Content'. What I understood is that we ought to know the exact number beforehand to use 'Abort after rows' property and there is no other way to do it with parameters.

Thanks for the info.