How can you recover the session in sequential batches?
Answer / 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 |
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
How can we use mapping variables in informatica? Where do we use them?
What are two types of processes that informatica runs the session?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
what is metadata?
can every transfomation reusable?how?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
what is incremental aggregation ,with example?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.