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?
- 4 Answers
- 18054 Views
- I also Faced
- E-Mail Answers
Answer Posted / rekha
U CAN DO IT BY PERFORMANCE RECOVERY
WHEN THE SERVER RUNS THE RECOVERY SESSION , SERVER READS
THE DATA FROM OPR_SRVR_RECOVERY TABLE AND NOTES THE ROW ID
OF THE LAST ROW COMMITTED TO THE TARGET TABLE ,THEN
INFORMATICASERVER READS THE ENTIRE SOURCE AGAIN AND PROCESS
THE DATA FROM NEXT ROW
BY DEFAULT PERFORMANCE RECOVERY IS DISABLE ,HENCE IT WONT
MAKE ANT ENTRIES IN TO OPR_SRVR_RECOVERY TABLE
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can we get 1st record through Informatica(without sequence number).
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the procedure for creating independent data marts from informatica 7.1?
Quickly characterize reusable change?
How can you generate reports in informatica?
What are the components of the workflow manager?
How to do unit testing in informatica?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what are the Methods For Creating Reusable Transformations?
How many numbers of sessions can one group in batches?
What is lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the sql query overwrite in source qualifier in informatica
Differentiate between Load Manager and DTM?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
