restarting the job from failure

[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.

[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.