Describe the effect of the "checkpoint" t-sql statement?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is de-partition in abinitio?
What do you know about partition and also tell us about partition components in abinitio?
List out the file extensions used in abinitio?
What metadata importer can do in ab initio?
What is the function that transfers a string into a decimal?
What is a look-up?
What a local lookup is?
What does edp stand for?
What do you understand by a cartesian join?
Explain how you can run a graph infinitely in ab initio?
What are the six data process products of ab initio (architecture of ab initio)?
What is is a data flow graph?
How to add default rules in transformer?
Explain the methods to improve performance of a graph?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?