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 ?
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of repositories created using informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can you differentiate between powercenter and power map?
What are the settings that you use to configure the joiner transformation?
What is a router transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Explain pmcmd command usage in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a surrogate key?
Differentiate between router and filter transformation?
Under what condition selecting sorted input in aggregator may fail the session?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to generate sequence numbers without using the sequence generator transformation?
What is union transformation in informatica?