It is mandatory to load the required columns of the base tables. If one or more required fields are missed, then the EIM process will fail to load the base table and generate the REQUIRED_COLS error status. To identify which are the required columns for a base table, the following query can be used:
SELECT TBL.NAME, COL.NAME
FROM S_COLUMN COL, S_TABLE TBL
WHERE COL.TBL_ID=TBL.ROW_ID
AND COL.REQUIRED='Y'
AND TBL.NAME = <<give Base Table Name here>>;
Similarly to determine the user keys for a base table, the following query can be used:
SELECT distinct TBL.NAME,
COL.NAME
FROM S_COLUMN COL,
S_TABLE TBL
WHERE COL.TBL_ID=TBL.ROW_ID
AND TBL.NAME = <<give Base Table Name here>>
AND COL.USR_KEY_SEQUENCE IS NOT NULL;
If the above query does not return any row, then that implies that the corresponding base table does not have any user key.