How can you recover the session in sequential batches?
Answer Posted / swetha
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the prerequisite tasks to achieve the session partition?
As union transformation gives UNION ALL output, how you will get the UNION output?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Under what condition selecting sorted input in aggregator may fail the session?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is target designer and target load order?
Write the unconnected lookup syntax?
What is the command used to run a batch?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How can you define user defied event?
Explain how many types of dimensions are available in informatica?
Differentiate between router and filter transformation?
Why sorter is an active transformation?
How can we improve session performance in aggregator transformation?
How to update or delete the rows in a target, which do not have key fields?