Suppose there are 100,000 rows in the source and 20,000 rows are loaded to target. Now in between if the session stops after loading 20,000 rows how will you load the remaining rows?
Hi, Informatica server has 3 methods torecover the sessions: (1)run the session again if the Informatica server has not issued a comit (2)truncate the target tables and run the session again if the session is not recoverable (3)consider perform recovery if the Informatica server has issued at least one commit
So for your question,use Perform recovery to load the records from where the session fails.
Hi, Ur ans is good but as i heared there is a chance even server has not issued a commit we can load from where it stopped. If u know pl let me know Thanq.
hi, In this type of scenario when loading process abruptly aborted and we have only 20k records loaded in table first we have to check the commit point in the session properties if the no rows stated in the commit point is less then the number of rows loded in table then we can run the mapping again or else we after that commit point we can run it for left out row
How would you know whether the server commited or not?
You can run the session again by setting the recovery opton enable and recover the session..which starts processing from the point where it was stopped..but for your information we generally don't check the recovery option in session before running session........if you anticipate the session will stop / fail due to error...then you must check this recovery option and then run again once the error is corrected...
