Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 11 Feb 2002 @ 21:54:53 GMT

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

Subj:   Re: Insert data into table
From:   Walt Craig

Yes, it is true, any Unique index will preclude duplicate rows. Don't know why someone would recommend Multiset over Set except that Teradata never allowed duplicate rows, whereas ANSI standard does. (Ted Codd would croak at the thought!) The Teradata default is Set and I had a client whose data required that we accept duplicates so we had to change the table definitions to MULTISET. Hard for me to see where that might be useful, but the client was happy having two or more rows with exactly the same data. Made sense when loading the data from the source, but once it was loaded and cleaned those duplicate rows should no longer had any meaning.

Walt Craig
Baseline Consulting Group, Inc.

  <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