Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 5419 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 |
Why might you create a stored procedure with the with recompile option?
What is the ab initio business rules environment (bre)?
Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?
Why creation of temporary files depends on the value of MAX CORE ? How to use in abinitio graph? 10. What is the diff between abinitiorc and .abinitiorc files ? How to use in abinitio graph? 11. What is the use of allocate()? How to use in abinitio graph? 12. What is use of branch in EME ? 13. How you can break a lock in EME ? How can you lock a file so that only no one other than EME admin can break it ? How to use in abinitio graph? 14. When you should be using ablocal() ? How you can use ablocal_expr? How to use in abinitio graph? 15. Why you should not keep the layout as 'default' for input table component ? How to use in abinitio graph? 16. What is dynamic lookup ? How to use in abinitio graph? 17. What is dependent parameter ? How to use in abinitio graph? 18. What is BRE ? (Business Rule Environment - This is a recent addition in abinitio package) How to use in abinitio graph? 19.What is output index ? How to use in abinitio graph? 20. How you can track the records those are not getting selected from ‘select’ in reformat component ? How to use in abinitio graph? 21. Can we have more than one launcher process for a particular graph ? How about agent ? How to use in abinitio graph? 22. There are lot of new fuctions added in 2.15 , you can ask about them ? How to use in abinitio graph? 23. How can you run multiple instances of a graph in parallel? How to use
What exactly do you understand with the term data processing and businesses can trust this approach?
What are the benefits of data processing according to you?
Name the different type of processing based on the steps that you know about?
how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio
Describe the grant/revoke ddl facility and how it is implemented?
How to run a graph infinitely?
what is the difference between i)public ii)private iii)common and client projects?
Mention what is the syntax for m_dump in abinitio?
Teradata 
