If a workflow stops or fails after loading 10k records ?
How can you recover it and If there is no order while
reading data from source ?

Answers were Sorted based on User's Feedback



If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no..

Answer / abhinaw prakash

Informatica has something called Recovery option for
recovering data.
If we have provided commit after say 10k records then it ll
start from where it failed i.e @ 10k.

Is This Answer Correct ?    9 Yes 1 No

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no..

Answer / prateek singh rana

informatica has one property in session level called
recovery stragy, we use it and take as ''resume from last
check point'' and run the workflow on recovery mode.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is the method of error handling when session is running?

1 Answers   TCS,


What you know about transaction control transformation?

0 Answers  


Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,


What is dimensional table? Explain the different dimensions.

0 Answers  


Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,






What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,


How can repository reports be accessed without sql or other transformations?

0 Answers  


Difference between task flow and linear task flow

0 Answers  


Hi All, I have three question. 1) How to remove the header and footer in a flat file in informatica? 2)How to load the first and last record of flat file into the target? 3)I have a Input and Output table. Input Name Salaray Month A 100 Jan A 200 Feb A 300 March B 400 April B 500 May B 600 June Output Name Salaray Month A 100 Jan A 300 Feb A 600 March B 400 April B 900 May B 1500 June How to implement and get the ouput as mentioned above. If Possible kindly provide the SQL query also. Kindly any one help to implement this concept. Thanks, Pradeep

3 Answers   CSC, iNautix,


how much memory (size) occupied by a session at runtime

4 Answers   Wipro,


What is a passive transformation?

0 Answers   Informatica,


what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,


Categories