Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 21 Feb 2001 @ 14:10:46 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016