| |
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? |
| March 03, 2008 16:22:31 |
#4 |
| sudeep0204 |
Member Since: March 2008 Total Comments: 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 |
| |
Back To Question | |
