Tuesday, June 26, 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:
Columns Description
[Columns of the checked table] The error table contains all the columns of the checked datastore.
ERR_TYPE Type of error:
  • 'F' when the datastore is checked during flow control
  • 'S' when the datastore is checked using static control
ERR_MESS Error message related to the violated constraint
CHECK_DATE Date and time when the datastore was checked
ORIGIN Origin 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_NAME Name of the violated constraint.
CONS_TYPE Type of the constraint:
  • 'PK': Primary Key
  • 'AK': Alternate Key
  • 'FK': Foreign Key
  • 'CK': Check condition
  • 'NN': Mandatory column

No comments:

Post a Comment