If a session fails after loading of 10,000 records in to the
target. How can you load the records from 10001 th record
when u run the session next time?
Answer Posted / srini
By setting session property as Resume last check point you
can acheive the same.Make sure that all recovery tables
PM_RECOVERY,PM_TGT_RUN_ID is created in the target database
or Realtion connection User have the
create,grant,insert,update previliages on target database.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between Load Manager and DTM?
Performance tuning( what you did in performance tuning)
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Define enterprise data warehousing?
Why union transformation is an active transformation?
What is the cumulative sum and moving sum?
Tell me about MD5 functions in informatica
How to Create a folder using pmrep command?
Enlist the tasks for which source qualifier transformation is used.
my source is junk data how will u remove that junk data by using unix please any one replay me
Differentiate between router and filter transformation?
What is confirmed fact in dataware housing?
How to generate sequence numbers?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the limitations of joiner transformation?