Archives of the TeradataForum
Message Posted: Wed, 03 Dec 2003 @ 12:43:57 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|