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 |
What will be the skew for, input file->partition by key-> partition by round robin->output file
Explain what is sort component in abinitio?
We have file having country_name customer_name.For exp London Ram Bangalore Rohit London Shyam Bangalore Abhinav In output we need 2 files one file for london and second file for Bangalore.How to acheve this?
what is the difference between .dbc and .cfg file?
How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?
Explain the methods to improve the performance of a graph?
What do you understand by overflow errors?
Explain how abinitio eme is segregated?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What is a deadlock and how it occurs?
What is the function you would use to transfer a string into a decimal?