How will you get 21 to 30 record from 50 records?

Question

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

Answer 1

select * from table where rownum<=30

minus

select * from table where rownum<=21;

Other than the above ans:

Using sequence generator, expression and filter transformation
OR

Using mapping variable initialised to zero, expression and filter transformation.