Hi guys,
I have encounter a problem in SAS data integration studio 3.4.
The problem is like this. After a transformation, all the data will output into an temp target table. Then I load this data using the table loader into the target table
Before I loaded into the target table, the temp target table has 80000 records.
After I loaded into the target table, the target table has 70000 records.
It is due to:
WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0001_.
(Occurred 498 times.)
WARNING: Add/Update failed for data set STG_SEAB.PERSONAL because data value(s) do not comply with integrity constraint _NM0002_.
(Occurred 9312 times.)
So how to solve this problem?
Thanks.
Yours Sincerely,
helphelp