pal

• Feb 9th, 2007

 

Session recovery is used when you want the session to continue loading from the point where it stopped last time it ran.for example if the session failed after loading 10,000 records, and you want the 10,001 record to be loaded then, you can use session recovery to load the data from 10,001.

vizaik

 Profile Answers by vizaik 

• Mar 25th, 2007

 

when ever session fails, then we have to follow these steps:

if no commit is performed by the informatica server, then run session again.

if at least one commit is performed by the session, recover the session.

if recover is not possible, truncate the target table and load again.





recovery option is set in the informatica server.  i just forgotten where to do recovery,  i will tell you next time or you search for it

dl_mstr

 Profile Answers by dl_mstr 

• Feb 10th, 2008

 

If the recover option is not set and 10,000 records are committed then delete the record from the target table using audit fields like update_date.