Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Configuring input parameters

Configuring input parameters

The
Input Parameters
page displays differently depending on the basis for the task. If the mapping does not contain input parameters, the page doesn't display.
The
Input Parameters
page displays input parameters such as filter and lookup conditions, field mappings, and expressions. It also displays stored procedure connections. It doesn't display source, target, or lookup connections and objects.
  1. Configure the parameters that display.
    Depending on the mapping data flow, you might need to configure some parameters before you configure other parameters. For more information, see
    Mappings
    .
    If the mapping contains a filter parameter, the task might display as valid even if you haven't configured the filter value. You must configure all parameters before the task is valid and you can run it.
  2. If necessary, configure stored procedure details.
    This displays when a stored procedure requires a connection. Select a connection or optionally create a new one.
  3. If necessary, configure lookup conditions.
    This displays when the lookup condition is parameterized.
  4. If necessary, configure mapplet details.
    This displays when a mapplet requires a connection and the mapplet is configured to display on this page.
    For some connection types, you can select
    Display technical field names instead of labels
    to display technical names instead of business names.
    To display fields in alphabetical order, click
    Display mapplet fields in alphabetical order
    .
  5. If necessary, configure field mappings.
    This displays when the field mapping is parameterized. Use the
    Object
    list to display fields from different objects.
    Map fields in one of the following ways:
    • To automatically map fields with the same name, click
      Automap
      Exact Field Name
      . Or, to map fields with similar names, click
      Automap
      Smart Map
      .
      You can undo all automapped field mappings by clicking
      Smart Map
      Undo Automap
      . To unmap a single field, select the field to unmap and click
      Actions
      Unmap
      .
    • To manually map fields, select and drag the source fields to the applicable target fields.
  6. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!