The validation errors of root fields and each field group are captured in separate field groups. The field groups that capture the validation errors inherit the name of the parent field as a prefix and use _Error as the suffix.
For example, the field group PostalAddress_Error captures the validation errors of the PostalAddress field group.
Note: Effective in the May 2023 release, the ability to map input fields that have validation errors to the target fields is available for preview.
Preview functionality is supported for evaluation purposes but is unwarranted and is not supported in production environments or any environment that you plan to push to production. Informatica intends to include the preview functionality in an upcoming release for production use, but might choose not to in accordance with changing market or technical circumstances. For more information, contact Informatica Global Customer Support.
If you want to identify the fields that contain validation errors in the exported data, you can map input fields that contain validation errors to target fields.
The following image shows the fields within the PostalAddress_Error field group mapped to the target fields:
The following table describes the field groups that capture the validation errors:
Field Name
Description
parentID
The sourcePkey value of the parent field group to which the fields with the validation errors belong. For example, the parentID field in the PostalAddress_Error field group contains the sourcePkey value of the PostalAddress field group.
errorColumn
Name of the field that has validation errors.
Note: The errorColumn field doesn't include the names of field groups that have validation errors.
errorSeverity
The severity of the validation error. For example, warning or information.
ruleName
The name of the data quality rule association that returns the error.
errorMessage
The message associated with the validation error.
Note: When multiple fields within a field group contain the same validation error, the fields are combined into a single row in the exported data.
