If the session fails after 100 records again we have to starts the session or we go for recovery session?

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

informatcia server has 3 methods to recovering the sessions.

1)Run the session again if the Informatica Server has not issued a commit.

2)Truncate the target tables and run the session again if the session is not recoverable.

3)Consider performing recovery if the Informatica Server has issued at least one commit.

Use performing recovery to load the records from where the session fails.