Part II: Getting Started with Informatica Developer > Lesson 6. Validating Address Data > Task 3. Configure the Address Validator Transformation
  

Task 3. Configure the Address Validator Transformation

In this task, you configure the Address Validator transformation to read and validate addresses from the All_Customers data source.
Note: The Address Validator transformation contain a series of predefined input and output ports. Select the ports you need and connect them to the objects in the mapping.
To configure the transformation, complete the following steps:
    1. Select the default address reference dataset.
    2. Configure the transformation ports and connect the transformation to the mapping.
    3. Connect unused source ports to the data target.

Step 1. Set the Default Address Reference Dataset

In this step, you select the default reference dataset. Address reference data files are defined by country, so you select a country name as the default dataset. The Address Validator transformation uses reference data relating to this country if it cannot determine the country to use from the input data values.
    1. Select the Address Validator transformation in the editor.
    2. Under Properties, click General Settings.
    3. In the Default Country menu, select United States.

Step 2. Configure the Address Validator Transformation Input Ports

In this step, you select transformation input ports and connect these ports to the All_Customers_av data object.
The Address Validator transformation contains several groups of predefined input ports. Select the input ports that correspond to the fields in your input address and add these ports to the transformation.
Hold the Ctrl key when selecting ports in the steps below to select multiple ports in a single operation.
    1. Select the Address Validator transformation in the editor.
    2. Under Properties, click Templates.
    3. Expand the Basic Model port group.
    4. Expand the Hybrid input port group and select the following ports:
    Port Name
    Description
    Delivery Address Line 1
    Street address data, such as street name and building number.
    Locality Complete 1
    City or town name.
    Postcode 1
    Postcode or ZIP code.
    Province 1
    Province or state name.
    Country Name
    Country name or abbreviation.
    Note: Hold the Ctrl key to select multiple ports in a single operation.
    5. On the toolbar above the port names list, click Add port to transformation.
    This toolbar is visible when you select Templates.
    The selected ports appear in the transformation in the mapping editor.
    6. Connect the source ports to the Address Validator transformation ports as follows:
    Source Port
    Address Validator Transformation Port
    Address1
    Delivery Address Line 1
    City
    Locality Complete 1
    ZIP
    Postcode 1
    State
    Province 1
    Country
    Country Name

Step 3. Configure the Address Validator Transformation Output Ports

In this step, you select transformation output ports and connect these ports to the All_Customers_av_tgt data object.
The Address Validator transformation contains several groups of predefined output ports. Select the ports that define the address structure you require and add these ports to the transformation.
You can also select ports containing information on the type of validation achieved for each address.
    1. Select the Address Validator transformation in the mapping editor.
    2. Under Properties, click Templates.
    3. Expand the Basic Model port group.
    4. Expand the Address Elements output port group and select the following port:
    Port Name
    Description
    Street Complete 1
    Street address data, such as street name and building number.
    5. Expand the Last Line Elements output port group and select the following ports:
    Port Name
    Description
    Locality Complete 1
    City or town name.
    Postcode 1
    Postcode or ZIP code.
    Province Abbreviation 1
    Province or state identifier.
    Note: Hold the Ctrl key to select multiple ports in a single operation.
    6. Expand the Country output port group and select the following port:
    Port Name
    Description
    Country Name 1
    Country name.
    7. Expand the Status Info output port group and select the following ports:
    Port Name
    Description
    Mailability Score
    Score that represents the chance of successful postal delivery.
    Match Code
    Code that represents the degree of similarity between the input address and the reference data.
    8. On the toolbar above the port names list, click Add port to transformation.
    This toolbar is visible when you select Templates.
    9. Connect the Address Validator transformation ports to the All_Customers_av_tgt ports as follows:
    Address Validator Transformation Port
    Target Port
    Street Complete 1
    Address1
    Locality Complete 1
    City
    Postcode 1
    ZIP
    Province Abbreviation 1
    State
    Country Name 1
    Country
    Mailability Score
    MailabilityScore
    Match Code
    MatchCode

Step 4. Connect Unused Data Source Ports to the Data Target

In this step, you connect the unused ports on the All_Customers data source to the data target.
    bulletConnect the unused ports on the data source to the ports with the same names on the data target.