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
How do you handle two sessions in Informatica
What differs when we choose the sorted input for aggregator transformation?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the prerequisite tasks to achieve the session partition?
What are some examples of informatica etl programs?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is Index Caches size?
Where do we use mapping variables in informatica?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Explain transaction control transformation in informatica
What is a joiner transformation and why it is an active one?
What are the designer tools for creating transformations?
How we can use union transformation?
what is SDLC way of code development?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa