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

How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?

0 Answers  

What is sandbox?

0 Answers  

What is meant by Co > Operating system and why it is special for Ab-initio ?

2 Answers  

) How can you count the total no .of records in the specified partition in the Multifile?

5 Answers  

What information is provided by .dbc file extension for connecting to the database?

0 Answers  

What are the key elements of a data processing system?

0 Answers  

) Layout? What is the Dataset & Program Component Layout

2 Answers   TCL,

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id thanks in advance...................................

0 Answers  

Name the different type of processing based on the steps that you know about?

0 Answers  

What do you mean by continuous graph? what is it significance?

1 Answers   IBM,

What is the significance of record required indicator of Join component ?

1 Answers   HCL,

What do you know about abinitio?

0 Answers