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 Parser Transformation

Step 4. Configure the Parser Transformation

In this step, you configure the Parser transformation to parse the column containing the full customer name into separate columns that contain the first name and last name.
  1. Select the editor containing the
    ParserMapping
    mapping.
  2. Click the Parser transformation.
  3. Click
    Window
    Show View
    Properties
    .
  4. In the Properties view, select the
    Strategies
    view.
  5. Click
    New
    . The New Strategy wizard displays.
  6. Click the selection arrow in the Inputs column, and choose the
    FullName
    port.
  7. Select the character space delimiter [\s].
  8. Click
    Next
    .
  9. Select the
    Parse using Token Set
    operation, and click
    Next
    .
  10. Select
    Fixed Token Sets (Single Output Only)
    and choose the
    Undefined
    token set.
  11. Click the
    Outputs
    field and select
    New
    .
  12. In the
    Operation Outputs
    dialog box, change the output name to
    Undefined_Output
    .
  13. Click
    Finish
    .
  14. In the Parser transformation, click the
    Undefined_Output
    port and drag it to the
    FirstName
    port in the
    LA_customers_tgt
    data object.
    A connection appears between the ports.
  15. In the Parser transformation, click the
    OverflowField
    port and drag it to the
    LastName
    port in the
    LA_customers_tgt
    data object.
    A connection appears between the ports.
  16. Click
    File
    Save
    to save the mapping.

0 COMMENTS

We’d like to hear from you!