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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How do you promote a non-reusable transformation to reusable transformation?
What are the new features of informatica 9.x at the developer level?
Separate from a database, an information bazaar, and an information stockroom?
Differentiate between a repository server and a powerhouse?
What is the surrogate key?
Explain the features of connected and unconnected lookup.
What are the different types of transformation available in informatica.
What can we do to improve the performance of informatica aggregator transformation?
What is the difference between a connected look up and unconnected lookup?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
write a query to retrieve the latest records from the table sorted by version(scd)
What is union transformation in informatica?
Explain the informatica workflow?