How to recover the standalone session?

Answers were Sorted based on User's Feedback



How to recover the standalone session?..

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

How to recover the standalone session?..

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

Post New Answer

More Informatica Interview Questions

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,


source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,


Implementation methodology

0 Answers  


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,


Describe two levels in which update strategy transformation sets?

1 Answers  






any body can say about all versions of informatica ?how many versions ?

2 Answers  


HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,


Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


How can u work with remote database in informatica?did you work directly by using remote connections?

2 Answers  


difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,


HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,


Categories