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


Please Help Members By Posting Answers For Below Questions

What is the use of the co> operating system in ab initio?

864


What is the function that transfers a string into a decimal?

917


What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

985


Explain what is sandbox?

852


What do you mean by a transaction file and how it is different from that of a sort file?

856


How can you export a component’s internal parameters ?

2162


How you can run a graph infinitely in ab initio?

1167


explain the environment varaibles with example?

866


Can you explain data flow graph with an example?

978


What metadata importer can do in ab initio?

978


What are the fundamental blocks of co> operating system of ab initio?

985


explain checkin and checkout?

902


What does edp stand for?

935


What is a partition?

949


What parallelisms does Abinitio support?

974