Based on commit interval session commits those many records into target.suppose if commit interval is 1000 if session fails after 100 records it won't insert not a single record into target.
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?
Suppose we have a Source Qualifier transformation that populates two target tables. How do we ensure TGT2 is loaded after TGT1?