This message appears when an INSERT statement attempts to insert a null value into a column that participates in a PRIMARY KEY constraint, or on which a NOT NULL constraint is defined. None of the columns that are part of a primary key can have null values; while a NOT NULL constraint ensures that the column contains no null values.
that when loading into a table through the Data Vault Loader, omitting a NOT NULL column from the mapping section of the load specification script will always cause the operation to fail with this error. Since the column is omitted, the Data Vault Loader will attempt to load the column with default null values, which are disallowed because of the NOT NULL constraint.