Explain about perform recovery?
- 1 Answers
- 5498 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
Why update strategy and union transformations are active?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
Explain pushdown optimization and types in informatica
What is meta data and system catalog?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
If we are using an aggregator but forget to mention the group by port .what will be the output??
How to eliminate duplicates in FF and oracle both
What is an unconnected transformation?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by lookup transformation?
Teradata 
