Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Step 4. Configure a target

Step 4. Configure a target

In the following procedure, you create a parameter for the target object so that each time you run the
mapping
task, you can select a different target.
For example, you might want files that only include data for the states you specify in the filter parameter when you run the
mapping
task. When you run the task, if you filter for accounts in California, you can select the file that contains data for California accounts as the target.
  1. On the mapping canvas, click the Target transformation to select it.
  2. To name the Target transformation, in the
    Properties
    panel, click
    General
    and enter
    tgt_Accounts_by_State
    for the Target transformation name.
  3. Click
    Target
    and configure the following properties:
    Target detail
    Description
    Connection
    Connection to the target file.
    You want the target object to be a flat file and you want the target object to reside in the same location as the source file. You can use the same connection that you used for the source because the source is a flat file as well.
    Target Type
    Target object or parameter.
    You want to parameterize the target object so that you can have separate files for each state, so select
    Parameter
    .
    Parameter
    Parameter to use for the target object. This field only appears when you select
    Parameter
    as the target type.
    Click
    New Parameter
    , and for the parameter name, enter
    p_StateTargetParameter
    . For the display label, enter
    Accounts for State
    .
    Click
    OK
    .
    The following image shows the properties for the tgt_Accounts_by_State Target transformation:
    The Properties panel for tgt_Accounts_by_State shows the settings you made for the target connection, target type, and parameter.
  4. Click
    Field Mapping
    and for
    Field map options
    , select Automatic. You cannot specify field mappings because the target object is parameterized. Because you can select different target objects each time you run the task, the fields in the target objects might not be the same each time you run the task.
  5. Click
    Save
    . You now have a complete mapping.