Archives of the TeradataForum
Message Posted: Tue, 24 Jan 2012 @ 21:01:54 GMT
U have duplicates (with respect to the PI).
Run the following query
Select Prod_Id, count (*) From DW_T_Test.Prod Group by 1 Having count (*) > 1 ;
If even one value of prod-id has a count of 2 or higher, it fails the UPI requirement.
Attempts to insert a duplicate record when a UPI is present will gen an error message.
Bill Gregg, Teradata DBA, GE
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|