Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 27 Sep 2001 @ 14:51:59 GMT

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

Subj:   Re: Updates using MLOAD SESSIONS
From:   John Street

The Mutliload utility does all the sequence handling in the background for you automatically. e.g. the inserts/updates will be applied in the sequence that they were read from the input file. On the record when it is send down to the Teradata system there is a ImportSeq fields added to the record (there are others as well)

The number of sessions is used for the import phase, e.g. when the data is read from the file then passed down to the Teradata system and then stored in the work tables. After this there is on one "session" , running the multiload processes against ALL VProcs. So in essence if you stated 20 sessions for a 48 Vamp system the aquisition phase would use 20 sessions to load the data into the work tables(in parallel) then a single all amp process will take the data in the work tables and apply them in parallel to all 48 amps.

hope this helps?



  <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: 15 Jun 2023