Interested to Buy Any Domain ? << Click Here >> for more details...
Describe the effect of the "checkpoint" t-sql statement?
- 1 Answers
- 5488 Views
- I also Faced
- E-Mail Answers
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 |
what is the difference between i)public ii)private iii)common and client projects?
What do you mean by a transaction file?
How you can create cross joined output using join component ?
Is data warehousing different from data mining?
Describe the process steps you would perform when defragmenting a data table. This table contains mission critical data?
Can you read multiple input files using one input file component ?(same DML)
What is common among data validity and data integrity?
I had 10,000 records r there i loded today 4000 records, i need load to 4001 - 10,000 next day how is in Type 1 and how is it on type 2?
What dedup-component and replicate component does?
How we can remove temp files of a failed job if .rec is not available ? How to use in abinitio graph?
Describe how you would monitor and control database physical file size and growth?
. What is flow buffering ? How it reduces the chances of having deadlock ?
Teradata 
