Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 5402 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 meant header and tailer, suppose header and tailer had some junk data how will delete junk data ? which components r used?
from a graph how to select only second record always in scan?
In which scenario, .rec files will not get created even if graph fails ? How to use in abinitio graph?
To which project that prefix will set is to private project or public project or both?how and where to set?
What is rollup component?
How transaction file different from that of a sort file?
What are differences between different versions of co-op?
Mention some file extensions which are used in abinitio?
What does it mean by the term 'sort component'?
How to create repository in abinitio for stand alone system(local nt)?
What are the benefits of data analyzing?
What are the prioritized Rules in as Transform function
Teradata 
