lately, i've been pondering about error handling

is there a way to get last row read as a variable to retry the job instead using loop to reread whole database from start?

something like this

transformation ---x--->get variable (last row read)------>set variable
^++++++++++++++++++++++++++++++++++++|
| ++++++++++++++++++++++++++++++++++++|
|------------------------------------------------------------------|