Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 5483 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create a repository in abinitio for stand-alone system(local nt)?
What is the difference between partitioning with key / hash and round robin?
Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?
Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
What the difference between “look-up” file and “look is up” in abinitio?
Explain what does dependency analysis mean in abinitio?
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?
What is a cursor? Within a cursor, how would you update fields on the row just fetched?
What is sandbox?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
What are the benefits of data analyzing?
Mention what the difference between “look-up” file and “look is up” in abinitio?
Explain the difference between the truncate and delete commands?
Can anyone give me an example of realtime start script in the graph?
We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?
