Describe the effect of the "checkpoint" t-sql statement?
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 |
Pdl with an example?
what is hash file in abinitio? how will it read in abinitio? in hash file the data files r combine (file1.dat,file2.dat,file3.dat......etc) how will it divide?
Define ramp limit in ab initio?
What mpjret contains ? How to use in abinitio graph?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
what is the difference between .dbc and .cfg file?
What parallelisms does Abinitio support?
Input - Name|city |startyear Rahul |Mumbai|2010 Rahul|kolkata|2014 Rahul|Delhi|2018 Output should be- Name|city |startyear|endyear Rahul |Mumbai|2010|2014 Rahul|kolkata|2014|2018 Rahul|Delhi|2018|9999
. What is flow buffering ? How it reduces the chances of having deadlock ?
What are the different versions and releases of ABinitio ?
Do you think effective communication is necessary for data processing?
Mention what is a partition and what are the different types of partition components in abinitio?