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 |
How to load the data from a flat file into the target where the source flat file name changes daily?
Slowly changing dimensions, types and where will you use them
What is router transformation
What is the status code?
What is joiner change?
What is predefined event?
performance tuning of Informatica
How to improve the performance of Aggregate transformation?
Can a joiner be used in a mapplet.
What is hash partition?
What are the types of data warehouses?
what is the difference between informatica6.1 and infomatica7.1