Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Working with Transformations
  3. Address Validator Transformation
  4. Aggregator Transformation
  5. Association Transformation
  6. Bad Record Exception Transformation
  7. Case Converter Transformation
  8. Classifier Transformation
  9. Cleanse transformation
  10. Comparison Transformation
  11. Custom Transformation
  12. Custom Transformation Functions
  13. Consolidation Transformation
  14. Data Masking Transformation
  15. Data Masking Examples
  16. Decision Transformation
  17. Duplicate Record Exception Transformation
  18. Dynamic Lookup Cache
  19. Expression Transformation
  20. External Procedure Transformation
  21. Filter Transformation
  22. HTTP Transformation
  23. Identity Resolution Transformation
  24. Java Transformation
  25. Java Transformation API Reference
  26. Java Expressions
  27. Java Transformation Example
  28. Joiner Transformation
  29. Key Generator Transformation
  30. Labeler Transformation
  31. Lookup Transformation
  32. Lookup Caches
  33. Match Transformation
  34. Match Transformations in Field Analysis
  35. Match Transformations in Identity Analysis
  36. Merge Transformation
  37. Normalizer Transformation
  38. Parser Transformation
  39. Rank Transformation
  40. Router Transformation
  41. Sequence Generator Transformation
  42. Sorter Transformation
  43. Source Qualifier Transformation
  44. SQL Transformation
  45. Using the SQL Transformation in a Mapping
  46. Stored Procedure Transformation
  47. Standardizer Transformation
  48. Transaction Control Transformation
  49. Union Transformation
  50. Unstructured Data Transformation
  51. Update Strategy Transformation
  52. Weighted Average Transformation
  53. XML Transformations

Transformation Guide

Transformation Guide

Element Result Status Output Port Values

Element Result Status Output Port Values

Element Result Status is a 20-character string in which each character represents a different input address element. The value for each character describes any update that the validation process makes to the address element.
Find the port in the Status Info port group.
The following table describes the Element Result Status port values:
Code
Description
0
The output address contains no data at the current position.
1
The transformation cannot find the data at the current position in the reference data. The transformation copies the input data to the output data.
2
Data at the current position is not checked but is standardized.
3
Data at the current position is checked but does not match the reference data. The reference data suggests that the number data is not in the valid range. The transformation copies the input data to the output port.
Applies in batch mode.
4
The transformation copies the input data to the output data because the reference data is missing.
5
Data at the current position is validated but not changed because multiple matches exist in the reference data.
Applies in batch mode.
6
Data validation deleted the input value at the current position.
7
Data at the current position is validated but the input data contained a spelling error. Validation corrected the error with a value from the reference data.
8
Data at the current position is validated and updated with a value from the reference data.
A value of 8 can also mean that the reference database contains additional data for the input element. For example, validation can add a building number or sub-building number if it finds a perfect match for the street name or building name.
9
Data at the current position is validated but not changed, and the delivery status is not clear. For example, the DPV value is wrong.
C
Data at the current position is validated and verified, but the name data is out of date. Validation changed the name data.
D
Data at the current position is validated and verified but changed from an exonym to an official name.
E
Data at the current position is validated and verified. However, address validation standardized the character case or the language.
Address validation can change the language if the value fully matches a language alternative. For example, address validation can change "Brussels" to "Bruxelles" in a Belgian address.
F
Data at the current position is validated, verified, and not changed, due to a perfect match with the reference data.
Positions 19 and 20 in the output string relate to country data.
The following table describes the values that validation may return for positions 19 and 20:
Code
Description
0
The output address contains no data at the current position.
1
Address validation does not recognize the country data.
4
Address validation identifies the country from the Default Country value in the Address Validator transformation.
5
Address validation cannot determine the country because the reference data contains multiple matches.
6
Address validation identifies the country from a script.
7
Address validation identifies the country from the address format.
8
Address validation identifies the country from major town data.
9
Address validation identifies the country from province data.
C
Address validation identifies the country from territory data.
D
Address validation identifies the country from the country name, but the name contains errors.
E
Address validation identifies the country from the address data, for example from an ISO code or a country name.
F
Address validation identifies the country from the Force Country value set in the Address Validator transformation.

0 COMMENTS

We’d like to hear from you!