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
| 
