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 mohanraju0113@gmail.com 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  






Categories