Page 1 of 1

restarting the job from failure

Posted: Wed Aug 13, 2008 12:38 pm
by psdsdev
Hi,

I would like to know how we cans restart the job from the record it failed to load. like 1001st row..

i know we usually do it by using target lookup or complete load by deleting target records. but how we can do this without lookup on target and complete loads. I know restartability logic will work only between the jobs not within job.

Posted: Wed Aug 13, 2008 2:29 pm
by chulett
Basically by keeping track of how far you got and then, when restarting, constrain your process to not start passing records until you get up to that point again.