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

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


Please Help Members By Posting Answers For Below Questions

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

873


What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

731


What are the facts that can compromise data integrity?

888


How can you import XML repositories exported from different tools like ODI

3337


What is the core of co> operating system?

847


What do you understand by local lookup?

863


What is a data processing cycle and what is its significance?

887


what is the output when -1 is put in select_expr of FBE?

1177


Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

808


Mention some ways for improving performance of a graph?

819


What are the different types of parallelism in ab initio?

980


How can a graph be run infinitely?

850


explain the environment varaibles with example?

839


What are the Types of parallelism in detail?

888


i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

1843