Part II: Getting Started with Informatica Developer > Lesson 6. Validating Address Data > Task 5. View the Mapping Output
  

Task 5. View the Mapping Output

In this task, you run the Data Viewer to view the mapping output. Review the quality of your validated addresses by examining the values written to the Mailability Score and Match Code columns in the target data object.
The Match Code value is an alphanumeric code representing the type of validation that the mapping performed on the address.
The Mailability Score value is a single-digit value that summarizes the deliverability of the address.
    1. In the Object Explorer view, find the All_Customers_av_tgt data object in your tutorial project and double click the data object.
    The data object opens in the editor.
    2. Select Window > Show View > Data Viewer.
    The Data Viewer opens.
    3. In the Data Viewer, click Run.
    The Data Viewer displays the mapping output.
    4. Scroll across the mapping results so that the Mailability Score and Match Code columns are visible.
    5. Review the values in the Mailability Score column.
    The scores can range from 0 through 5. Addresses with higher scores are more likely to be delivered successfully.
    6. Review the values in the Match Code column.
    Match Code is an alphanumeric code. The alphabetic character indicates the type of validation that the transformation performed, and the digit indicates the quality of the final address.
    The following table describes the Match Code values:
    Code
    Description
    A1
    Address code lookup found a partial address or a complete address for the input code.
    A0
    Address code lookup found no address for the input code.
    C4
    Corrected. All postally relevant elements are checked.
    C3
    Corrected. Some elements cannot be checked.
    C2
    Corrected, but the delivery status is unclear due to absent reference data.
    C1
    Corrected, but the delivery status is unclear because user standardization introduced errors.
    I4
    Data cannot be corrected completely, but there is a single match with an address in the reference data.
    I3
    Data cannot be corrected completely, and there are multiple matches with addresses in the reference data.
    I2
    Data cannot be corrected. Batch mode returns partial suggested addresses.
    I1
    Data cannot be corrected. Batch mode cannot suggest an address.
    N7
    Validation error. Validation did not take place because single-line validation is not unlocked.
    N6
    Validation error. Validation did not take place because single-line validation is not supported for the destination country.
    N5
    Validation error. Validation did not take place because the reference database is out of date.
    N4
    Validation error. Validation did not take place because the reference data is corrupt or badly formatted.
    N3
    Validation error. Validation did not take place because the country data cannot be unlocked.
    N2
    Validation error. Validation did not take place because the required reference database is not available.
    N1
    Validation error. Validation did not take place because the country is not recognized or not supported.
    Q3
    Suggestion List mode. Address validation can suggest one or more complete addresses.
    Q2
    Suggestion List mode. The suggested address is complete but includes elements copied from the input address.
    Q1
    Suggestion List mode. Address validation cannot suggest a complete address. The address needs more input data.
    Q0
    Suggestion List mode. There is insufficient input data to generate suggestions.
    RB
    Country recognized from abbreviation. Recognizes ISO two-character and ISO three-character country codes. Can recognize common abbreviations such as "GER" for Germany.
    RA
    Country recognized from the Force Country setting in the transformation.
    R9
    Country recognized from the Default Country setting in the transformation.
    R8
    Country recognized from the country name.
    R7
    Country recognized from the country name, but the transformation identified errors in the country data.
    R6
    Country recognized from territory data.
    R5
    Country recognized from province data.
    R4
    Country recognized from major town data.
    R3
    Country recognized from the address format.
    R2
    Country recognized from a script.
    R1
    Country not recognized because multiple matches are available.
    R0
    Country not recognized.
    S4
    Parse mode. The address was parsed perfectly.
    S3
    Parse mode. The address was parsed with multiple results.
    S1
    Parse mode. There was a parsing error due to an input format mismatch.
    V4
    Verified. The input data is correct. Address validation checked all postally relevant elements, and inputs matched perfectly.
    V3
    Verified. The input data is correct, but some or all elements were standardized, or the input contains outdated names or exonyms.
    V2
    Verified. The input data is correct, but some elements cannot be verified because of incomplete reference data.
    V1
    Verified. The input data is correct, but user standardization has negatively impacted deliverability. For example, the post code length is too short.