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
How to create repository in abinitio for stand alone system(local nt)?
What is a deadlock and how it occurs?
What do you know about partition and also tell us about partition components in abinitio?
Describe the elements you would review to ensure multiple scheduled batch jobs do not collide with each other?
What is the use of the co> operating system in ab initio?
How to create a repository in abinitio for stand-alone system(local nt)?
What is the importance of eme in abinitio?
Have you used rollup component? Describe how.
Define ramp limit in ab initio?
What are the types of data processing you are familiar with?
What is the max core of a component?
What are the Types of parallelism in detail?
What are “business rules” in ab initio business rules environment (bre)?
What is the purpose of having stored procedures in a database?
What are the factors on which storage of data depends?