| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Load the remaining rows
Answer: 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? |
| April 04, 2008 08:22:21 |
#5 |
| N SRIRAM K |
Member Since: May 2007 Total Comments: 21 |
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 |
| |
Back To Question | |
