Tuesday, 26 June 2012

Error Table Structure in oracle data integrator

Error Table Structure

The E$ error table has the list of columns described in the following table:
ColumnsDescription
[Columns of the checked table]The error table contains all the columns of the checked datastore.
ERR_TYPEType of error:
  • 'F' when the datastore is checked during flow control
  • 'S' when the datastore is checked using static control
ERR_MESSError message related to the violated constraint
CHECK_DATEDate and time when the datastore was checked
ORIGINOrigin of the check operation. This column is set either to the datastore name or to an interface name and ID depending on how the check was performed.
CONS_NAMEName of the violated constraint.
CONS_TYPEType of the constraint:
  • 'PK': Primary Key
  • 'AK': Alternate Key
  • 'FK': Foreign Key
  • 'CK': Check condition
  • 'NN': Mandatory column

No comments:

Post a Comment