Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2011 @ 14:03:30 GMT

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

Subj:   Re: Why fastload doesn't allow duplicates
From:   Jepamony, Johnpaul

Hi Suhel,

The restart logic is the reason, that FastLoad will not load duplicate rows into a MULTISET table.

During Restart of Fastload, Some more records may be sent to amp again after the check points which is recorded at the point of failure.

So these records were filtered as dupicate records after the sort in phase 2 of fastload.

That's why the fastload does not allow duplicates even if we have a mutliset table.



  <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: 15 Jun 2023