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 |
In joiner, how to load Master table in Target?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the different types of olap? Give an example?
one source to target loading insert new rows and update existing rows?
What is domain and gateway node?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
What are the types of lookup?
what is constraint based loading
What is dimensional table? Explain the different dimensions.
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
What is the default join that source qualifier provides?