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 / 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
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is sorter transformation?
Explain what transformation and how many are there in informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the use of an aggregator cache file?
What is the surrogate key?
What is Cognos script editor?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Why filter transformation is an active one?
Explain the aggregator transformation?
Which development components of informatica have the highest usage?
Differentiate between Load Manager and DTM?
What are the different types of repositories created using informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?