Archives of the TeradataForum

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

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

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?

Cheers

John

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