A problem with integrity constraint

[deleted_user]

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

[milts]

Hi,

Try to check the columns of your target table. probably some of your columns should not contain a null value and then you try to insert records with a null value on that particular column. Hope this helps.

regards,
milton