Archives of the TeradataForum
Message Posted: Mon, 16 Jul 2012 @ 17:39:37 GMT
Jay - Check the PI on your target table.
It is probably not 'unique enough' ( i.e. a lot of repeating values per PI, or is highly skewed). The following might options to consider:
(1) Consider changing the PI to be more unique, or
(2)changing the target table to MULTISET, instead of SET (will remove the duplicate check step), or
(3) consider changing the table to a no-PI table, if there isn't any good PI candidate column(s).
Johannes de Wet
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|