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 common Match Code values:
    Match Code
    Description
    V4
    Verified as deliverable by address validation. Input data is correct, and inputs are a perfect match with the reference data.
    V3
    Verified as deliverable by address validation. Input data is correct, but there was an imperfect match with the reference data. This is possibly due to poor standardization of address elements.
    V2
    Verified as deliverable by address validation. Input data is correct, but there was an imperfect match with the reference data. Some reference data files may be missing files.
    V1
    Verified as deliverable by address validation. Input data is correct but poor standardization has reduced address deliverability.
    C4
    Corrected by address validation. All elements have been processed and corrected where necessary.
    C3
    Corrected by address validation. All elements have been processed, but some elements could not be checked.
    C2
    Partially corrected by address validation. Some reference data files may be missing.
    C1
    Corrected by address validation, but poor standardization has reduced address deliverability.
    I4
    Input data could not be corrected, but the address is very likely to be deliverable as it matches a unique reference address.
    I3
    Input data could not be corrected, but the address is very likely to be deliverable as it matches multiple reference addresses.
    I2
    Input data could not be corrected, and deliverability is not likely.
    I1
    Input data could not be corrected, and deliverability is very unlikely.
    N1... N6
    No validation was performed. This may be due to an absence of current or licensed reference data. The address may or may not be deliverable.