Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category

Describe the effect of the "checkpoint" t-sql statement?

Question Posted / guest


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

Post New Answer

More Ab Initio Interview Questions

What is difference between force_error & force_abort? How to use in abinitio graph?

2 Answers   IBM, TCL,

What is regex (lookup)? When you should use it?

3 Answers   HCL,

Explain what is sort component in abinitio?

0 Answers  

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

0 Answers  

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

1 Answers  

What a local lookup is?

0 Answers  

What is the syntax for m_dump in abinitio?

0 Answers  

Runtime behavior of Normalize and Reformat

0 Answers  

How to move data from developement to testing and testing to production?

1 Answers   BitWise, CTS, Satyam, Wipro,

What is the DynamicScriptGeneration and what is the Use?

2 Answers  

EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer

3 Answers   Accenture,

Can you use scan to generate sequence number ? How to use in abinitio graph?

2 Answers   IBM, TCL,

For more Ab Initio Interview Questions Click Here
Categories