Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 25 Aug 2004 @ 10:17:07 GMT

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

Subj:   Re: MULTISET Vs SET tables
From:   Frank O Connor


The advantage of multiset tables is that they do not check for duplicate rows and this means that inserting data is quicker.

However, there can be a downside. For any given load, you may not load duplicates. You must be certain of that fact or else duplicate rows may be inserted. In addition, you may need to build in some form of checking to ensure that the same data is not loaded twice.

One level of protection is to add the teradata system time to each row. So, for a given INSERT/SELECT, the same system time will be added to each row. This provides a level of protection in that you can identify the second spurious load.

For Fastload and Multiload, you may have to accept in external date and time values to ensure you get a constant time for the load.

Hope this helps


  <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: 28 Jun 2020