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
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
When do you use sql override in a lookup transformation?
can we override a native sql query within informatica? How do we do it?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
Define enterprise data warehousing?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is sq transformation?
What do mean by local and global repository?
Differentiate between joiner and lookup transformation?
Explain Dataware house architecture .how data flow from intial to end?
What are the components of workflow manager?
How to update or delete the rows in a target, which do not have key fields?
What are the components of Informatica? And what is the purpose of each?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is lookup transformation?
