garunchowdary

 Profile Answers by garunchowdary Questions by garunchowdary

• Feb 29th, 2008

 

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.

Correct me if I was wrong,
Thanks...

tanya123

 Profile Answers by tanya123 Questions by tanya123

• Feb 29th, 2008

 

thank you for the reply..

vg.vasu

 Profile Answers by vg.vasu Questions by vg.vasu

• Mar 1st, 2008

 

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.

sudeep0204

 Profile Answers by sudeep0204 

• Mar 13th, 2008

 

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

N SRIRAM K

 Profile Answers by N SRIRAM K Questions by N SRIRAM K

• Apr 14th, 2008

 

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...


Thx
SRIRAM N

sahan

 Profile Answers by sahan 

• Jul 16th, 2009

 

You can do it by performing session recovery.
When you enable session recovery option, the integration service makes the entries to opb_session_recovery table and notes the row id of the last row committed to the target. When you run the session again the integration service read all the source data and start loading from the next row id.

If the integration service performs atleast one commit then you can perform recovery.