Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 26 Mar 2004 @ 13:52:37 GMT

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

Subj:   Re: Why does table need to be empty for Fastload
From:   Kabilan_Kanagasabai


Fastload supports only empty Teradata tables. The main purpose of fastload is to load large amounts of data into an empty table at high speed

As you said, in phase 1, the respective rows are present in AMPs but not sorted out in row hash sequence. Once enough rows are received to fill a block, the AMP writes the block to disk

During phase2, each AMP reads the data blocks from disk, sort the data rows based on row hash and write the data back to disk.

Hope I have answered your question


Satyam Computer Services Limited

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019