It is not possible to start loading the rows after 1000th row. but there are many ways you can achieve it.1) If the target table has current timestamp as a column then we can delete the rows having max timestamp and load all the rows from start.2) We can perform a look-up of source table with the target table to check if the rows exist in target table and insert only the non-existing rows.
By specifying Checkpointing in job sequence properties, if we restart the job. Then job will start by skipping upto the failed record.this option is available in 7.5 edition.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!