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
What are the restrictions of union transformation?
What does refresh system mean, and what are its distinctive choice?
What is informatica etl tool?
What is data movement mode in Informatica and difference between them?
How do you take back up of repository?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How to improve the performance of a session using sorter transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to generate sequence numbers using expression transformation?
What is a repository? And how to add it in an informatica client?
What is a filter transformation?
Explain about cumulative Sum or moving sum?
How does a rank transform differ from aggregator transform functions max and min?
tell me the rules and responsblites in our project(my project is development)