Table of Contents

Search

  1. Preface
  2. Getting Started Overview
  3. Getting Started with Informatica Analyst
  4. Getting Started with Informatica Developer
  5. Frequently Asked Questions

Getting Started Guide

Getting Started Guide

Step 4. Configure the Standardizer Transformation

Step 4. Configure the Standardizer Transformation

In this step, you configure the Standardizer transformation to standardize address terms in the source data.
You will define five standardization operations in this task. Each operation replaces a string in the input column with a new string.
  1. Select the editor that contains the
    StandardizerMapping
    mapping.
  2. Click the Standardizer transformation.
  3. Click
    Window
    Show View
    Properties
    .
  4. In the Properties view, select
    Strategies
    .
  5. Click
    New
    . The New Strategy wizard displays.
  6. Click the selection arrow in the Inputs column, and choose the
    Address1
    input port.
    The Outputs field shows
    Address1
    as the output port.
  7. Select the character space and comma delimiters [\s] and [,]. Optionally, select the options to remove trailing spaces.
  8. Click
    Next
    .
  9. Select the
    Replace custom strings
    operation, and click
    Next
    .
  10. Under
    Properties
    , click
    New
    .
  11. Edit the
    Custom Strings
    and
    Replace With
    fields so that they contain the first pair of strings from the following table:
    Custom Strings
    Replace With
    STREET
    ST.
    BOULEVARD
    BLVD.
    AVENUE
    AVE.
    DRIVE
    DR.
    PARK
    PK.
  12. Repeat steps 9 through 12 to define standardization operations for all strings in the table.
  13. Drag the
    Address1
    output port to the
    Address1
    port in the All_Customers_Stdz_tgt data object.
  14. Click
    File
    Save
    to save the mapping.

0 COMMENTS

We’d like to hear from you!