Sunday, March 16, 2008

Load the remaining rows

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?

1 comment:

Siddharth said...

Hi,
Informatica server has 3 methods to recover 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 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.
This can be done as follows.Right click on the session and select "Recover Task"