How to recover sessions in concurrent batches?
Answers were Sorted based on User's Feedback
Answer / krishna
when we use concurrent process to load when session
fails ...all other session will run normally and load the
data..the failed session will considered as a standalone
sesion ...and we have perform recovery for the failed
session.
there three type where we can recover a failed session
1.start the session again if the Informatica server doesnt
perform the commit
2.else perform recovery on the session
3. if we can recover the session truncacte the data from
target table and run the session.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / aswin
Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning
so manual intervention is required to restat the flatfile target load fails
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / seshagiri k
by removing the target table and run the session again
if it is wrong pls send the answer to my mail
Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between stored procedure transformation and external procedure transformation?
how can we run workflow with pmcmd?
How do you migrate data from one environment to another?
what type of transformation is not supported by mapplets?
Under which circumstances, informatica server creates reject files?
how can run the wf through pmcmd commend? write script?
why dimenstion tables are denormalized in nature ?
What are the rank caches?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.
Why we need XMLs?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")