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 |
sorce is a flatfile only 1st and last row should insert to target how will u do?
How do you load only null records into target? Explain through mapping flow.
explain abt joiner t/r?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)
3 Answers Alcatel-Lucent, ECI Telecom,
What is the Difference between SetVariable and setmaxvariable in informatica?
What is a pre-defined event and user-defined event?
 Informatica Checkpoints
What do think which one is the better joiner or look up?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is Cognos script editor?
Which means the first record should come as last record and last record should come as first record and load into the target file?