Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 4209 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 |
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Dear all, Please send me the ab initio pdfs and faqs i need... my mail id is rrajesh.intel@gmail.com
What do you understand by overflow errors?
What is the function you would use to transfer a string into a decimal?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
How transaction file different from that of a sort file?
Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...
wt is meant by repartioning in howmany ways it can be done.
How to Create Surrogate Key using Ab Initio?
How can you export a component’s internal parameters ?
What do you mean by a transaction file?
Teradata 
