 |
 |
Archives of the TeradataForum
Message Posted: Wed, 03 Dec 2003 @ 12:51:13 GMT
| Subj: | | Re: Fastload Acquisition Phase |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, December 03, 2003 07:38 -->
| | Yes.. I understand that it does transfer the data in blocks.. But when it transfers to the AMPs, how would it know, which block to go
to which AMP..? Some hashing principle should be there for distributing the block of rows into the different AMPs, I guess.. | |
FastLoad simply sends those blocks (up to 64 KB each in current versions) in round robin fashion to each AMP in the system, using
all sessions as David explained. Then each AMP must deblock the records, apply the hashing algorithm to proper field in each record, and
create new blocks in memory buffers for each other AMP in the configuration. When every such block is full it is sent to proper destination
AMP using a monocast message over the BYNETs. After last block is sent by FastLoad all partial buffers in each AMP are sent to corresponding
AMPs, and every AMP finally has all records that belong to it, according to hashing on the field which corresponds to Primary Index for the
table being loaded. Then AMPs are ready for Phase 2.
Best regards.
| |
