Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover the standalone session?
- 2 Answers
- 9575 Views
- I also Faced
- E-Mail Answers
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 |
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Name the different lookup cache(s)?
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
What is aggregate cache in aggregator transforamtion?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
How do you change a non-reusable transformation to reusable transformation?
What are the methods for creating reusable transforamtions?
What are data-driven sessions?
what is a transforamation?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Teradata 
