Answer Posted / nagaraju bhatraju
A standalone session is a session that is not nested in a
batch. If a standalone session fails, you can run recovery
using a menu command or pmcmd. These options are not
available for batched sessions.
To recover sessions using the menu:
1. In the Server Manager, highlight the session you want to
recover.
2. Select Server Requests-Stop from the menu.
3. With the failed session highlighted, select Server
Requests-Start Session in Recovery Mode from the menu.
To recover sessions using pmcmd:
1.From the command line, stop the session.
2. From the command line, start recovery.
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
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?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is meant by target load plan?
Please let me know how to make encryption and decryption with example?
Difference between Data and Index Caches?
Parameter and variable differences
What are the features of complex mapping?
What can we do to improve the performance of informatica aggregator transformation?
Why is sorter an active transformation?
Explain the aggregator transformation?
Which are the different editions of informatica powercenter that are available?
What is a pre-defined event and user-defined event?
What is a shortcut and copy in Informatica and how two are different with each other?
define galaxy repository in informatica
