How to recover the standalone session?
Answers were Sorted based on User's Feedback
Answer / nagaraju bhatraju
How to recover the standalone session?
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nagaraju bhatraju
If you configure a session in a sequential batch to stop on
failure, you can run recovery starting with the failed
session. The Informatica Server completes the session and
then runs the rest of the batch. Use the Perform Recovery
session property
To recover sessions in sequential batches configured to stop
on failure:
1.In the Server Manager, open the session property sheet.
2.On the Log Files tab, select Perform Recovery, and click
OK.
3.Run the session.
4.After the batch completes, open the session property
sheet.
5.Clear Perform Recovery, and click OK.
If you do not clear Perform Recovery, the next time you run
the session, the Informatica Server attempts to recover the
previous session.
If you do not configure a session in a sequential batch to
stop on failure, and the remaining sessions in the batch
complete, recover the failed session as a standalone
session.
How to recover the standalone session?
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
Explain the difference between a data warehouse and a data mart?
What are the reusable transforamtions?
Informatica settings are available in which file?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
what is incremantal aggregation?
How many number of sessions can one group in batches?
What are the mapping parameters and mapping variables?
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What is domain and gateway node?
how many tasks are there in informatica ?
15 Answers DELL, iGate, TCS,
Do you find any difficulty while working with flat files as source and target?