Archives of the TeradataForum
Message Posted: Thu, 27 Sep 2001 @ 14:51:59 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|