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


Please Help Members By Posting Answers For Below Questions

How to create repository in abinitio for stand alone system(local nt)?

706


What is a deadlock and how it occurs?

661


What do you know about partition and also tell us about partition components in abinitio?

588


Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?

604


What is the use of the co> operating system in ab initio?

608






How to create a repository in abinitio for stand-alone system(local nt)?

614


What is the importance of eme in abinitio?

661


Have you used rollup component? Describe how.

650


Define ramp limit in ab initio?

759


What are the types of data processing you are familiar with?

694


What is the max core of a component?

616


What are the Types of parallelism in detail?

691


What are “business rules” in ab initio business rules environment (bre)?

1409


What is the purpose of having stored procedures in a database?

619


What are the factors on which storage of data depends?

631