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
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 |
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 |
How do you recover rows from a failed session
What is the use of target designer?
Explain sql transformation in script mode examples in informatica
I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the different components of powercenter?
What are the different threads in DTM process?
What is factless fact schema?
How to generate sequence numbers using expression transformation?
can we use bulk loading when we use look in mapping
Name 4 output files that informatica server creates during session running?
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????