Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Import From PowerCenter
  13. Performance Tuning
  14. Pushdown Optimization
  15. Partitioned Mappings
  16. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Step 2a. Choose the Operator and Selection Criteria

Step 2a. Choose the Operator and Selection Criteria

Choose an operator to include or exclude ports and a selection criteria to filter ports based on port names or data types.
  1. From the
    Operator
    column, choose the
    Include
    or
    Exclude
    operator.
    The operator determines whether the rule must include or exclude ports.
    You can select the Input Rules option or the Include all remaining ports option in the Include/Exclude Ports area of the Input Rules dialog box. Input Rules contain three columns, Operator, Selection Criteria, and Detail. You can choose Include or Exclude from the Operator column.
  2. From the
    Selection Criteria
    column, choose one of the following options:
    • All
      . Includes all ports. Do not choose this option with the Exclude operator.
    • Name
      . Includes or excludes ports based on port names.
    • Type
      . Includes or excludes ports based on data type of the port.
    • Pattern
      . Includes or excludes ports based on patterns of port names.
    Input Rules contain three columns, Operator, Selection Criteria, and Detail. You can choose All, by Name, by Type, or by Pattern from the Selection Criteria column.
  3. From the
    Details
    column, click the Details arrow to provide the selection criteria details.
    The
    Input Rule Detail
    dialog box for the selection criteria appears.

0 COMMENTS

We’d like to hear from you!