Follow Our FB Page << CircleMedia.in >> 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  






Categories