Archives of the TeradataForum
Message Posted: Wed, 21 Feb 2001 @ 14:10:46 GMT
| Subj: | | Re: Multiset load restarts |
| |
| From: | | John Street |
Dave as normal is spot on.
One thing you need to watch out for though on a restart is the fact that there will be duplicate rows in the work table once you have
rerun prior to the exclusion of that data. Which means the work tables will be bigger than you anticipated (this is especially noticeable
on Mloads where there is no checkpointing (defaults to 15mins) and if there is a failure in the acquisition phase near the end you could end
up with almost twice the amount of worktable space required for the short term (for this sort of case a clean-up and rerun would be better
than a restart.) )
Cheers
John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited
| 
