Informatica - Load the remaining rows

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 604 of 644

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?

Total Answers and Comments: 6

Last Update: July 16, 2009 Asked by: tanya123

Sponsored Links

Best Rated Answer

—

Submitted by: garunchowdary

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

Above answer was rated as good by the following members:
phdsong, ayappan.a, ravikumar.amudala, avneeshrathor

February 29, 2008 12:57:30

garunchowdary

Member Since: February 2008 Contribution: 6

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

Correct me if I was wrong
Thanks...

Is this answer useful? Yes | No

2 0

Overall Rating: +2

February 29, 2008 13:54:15

tanya123

Member Since: February 2008 Contribution: 17

RE: Load the remaining rows

thank you for the reply..

Is this answer useful? Yes | No

March 01, 2008 05:28:59

vg.vasu

Member Since: March 2008 Contribution: 3

RE: Load the remaining rows

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.

Is this answer useful? Yes | No

March 13, 2008 16:22:31

sudeep0204

Member Since: March 2008 Contribution: 1

RE: Load the remaining rows

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

April 14, 2008 08:22:21

N SRIRAM K

Member Since: May 2007 Contribution: 115

RE: Load the remaining rows

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

Is this answer useful? Yes | No

July 16, 2009 06:19:32

sahan

Member Since: July 2009 Contribution: 10

RE: Load the remaining rows

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank