Archives of the TeradataForum

Message Posted: Wed, 03 Dec 2003 @ 12:43:57 GMT

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

Hi,

The Fastload/Multiload CLIENT doesn't know which amp to send any particular data block to. It essentially sends them to each AMP in turn (first block to first amp, second block to second amp etc).

The DBMS then breaks each data block into separate rows, and for each row passes the PI data values to the hashing algorithm, uses the rowhash to access the hash map(s) to find out which amp should deal with the row and sends the row to the correct AMP.

Cheers,

Dave

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