Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 3076 Views
- I also Faced
- E-Mail Answers
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 |
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?
How do we handle if DML changing dynamicaly?
5 Answers GE, HP, IBM, Mannar Company,
Is it possible to create a parameter in the component?
Explain what is de-partition in abinitio?
What is the difference between partitioning with key and round robin?
How you can run a graph infinitely in ab initio?
What is the diff between abinitiorc and .abinitiorc files ?
How to add default rules in the transformer?
Mention what is rollup component?
What are the Graph parameter?
Teradata 
