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
When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?
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.
What are the facts that can compromise data integrity?
How can you import XML repositories exported from different tools like ODI
What is the core of co> operating system?
What do you understand by local lookup?
What is a data processing cycle and what is its significance?
what is the output when -1 is put in select_expr of FBE?
Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
Mention some ways for improving performance of a graph?
What are the different types of parallelism in ab initio?
How can a graph be run infinitely?
explain the environment varaibles with example?
What are the Types of parallelism in detail?
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 ?