Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 5413 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 process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
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 ?
Within a cursor, how would you update fields on the row just fetched?
What is a rollup component? Explain about it.
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
How can you import XML repositories exported from different tools like ODI
Can you explain data flow graph with an example?
What do you mean by the term data warehousing?
Explain what is de-partition in abinitio?
How do you add default rules in transformer?
explain checkin and checkout?
How to find the project(pub,priv,common,client) in between public, Private,common?Any identification?
When we should use 'jobid' for commit table (Output table component??
Mention some ways for improving performance of a graph?
How is the partitioning with key different from round robin partition?
