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
What are the Types of parallelism in detail?
What are the key elements of a data processing system?
What are the benefits of data analyzing?
How transaction file different from that of a sort file?
What is de-partition in abinitio?
What is publickey and private key?what is the use of this two keys?
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
Can sorting and storing be done through single software or you need different for these approaches?
explain checkin and checkout?
What is $mpjret?
How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
Hi friends, what are the new features in abinito3.0?
What a local lookup is?
What information does a .dbc file extension provides to connect to the database?