Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 29 Dec 2011 @ 09:45:57 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Does SET Table with NUPI allow duplicates?
From:   Kenneth Hansen


For Teradata a row is only a duplicate if every column is identical.

Typically this occurs where the extract from source has insufficient attributes to make each row identical. Loading to a SET table will filter out those duplicates, loading to a MULTISET will allow those duplicates to persist.

A UPI or NUPI applies criteria only in respect of the column(s) comprised in the PI.

Good luck,

Kenneth Hansen

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