Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Describe the effect of the "checkpoint" t-sql statement?

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

Post New Answer

More Ab Initio Interview Questions

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

0 Answers  

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

0 Answers   CTS,

I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 Answers  

How do we handle if DML changing dynamicaly?

5 Answers   GE, HP, IBM, Mannar Company,

Is it possible to create a parameter in the component?

1 Answers  

Explain what is de-partition in abinitio?

0 Answers  

What is the difference between partitioning with key and round robin?

7 Answers   TCS, Wipro,

How you can run a graph infinitely in ab initio?

0 Answers  

What is the diff between abinitiorc and .abinitiorc files ?

1 Answers   IBM, Infosys, TCL,

How to add default rules in the transformer?

0 Answers  

Mention what is rollup component?

0 Answers  

What are the Graph parameter?

0 Answers