Informatica: How are indexes created after completing the load process?

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

Stored procedure transformation can be used to create and drop indexes before and after loading into the target.