Describe the effect of the "checkpoint" t-sql statement?
Answer / anonymous
checkpoints are normally used for the graph recovery.
if we are loading a large volume of data and the graph gets failed, so instead of rerunning the whole graph we can execute the graph from the last executed checkpoint.
it saves time and loads the data from the point where it failed.
checkpoints saves the intermediate files during the graph execution.
| Is This Answer Correct ? | 1 Yes | 0 No |
Describe which system or process elements you would review when trouble-shooting general server slows ?
If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.
What are the steps to create a repository in ab initio?
what are kinds of layouts does ab initio supports ?
. What is flow buffering ? How it reduces the chances of having deadlock ?
What is the DynamicScriptGeneration and what is the Use?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,
Mention some ways for improving performance of a graph?
What are the co> operating system’s assorted library of integrated components?
What are the differences between informatica and abinitio?
What is m_dump?
What are the six data process products of ab initio (architecture of ab initio)?