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. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Step 2d. Configure the Pattern Selection Criteria Details

Step 2d. Configure the Pattern Selection Criteria Details

If you choose the pattern selection criteria for the input rule, choose a pattern type for the port name. Enter a value for the pattern or use a parameter of type String to specify the value that you can change at run time.
  1. In the
    Input Rule Detail: By Pattern
    dialog box, select one of the following from the
    Pattern Type
    list:
    • Prefix. To include or exclude port names that start with the prefix string.
      For example, if you enter the prefix value
      E
      , the input rule filters the port names that start with E or e such as EmpNo, empName, and EmpTitle.
    • Suffix. To include or exclude port names that end with the suffix string.
      For example, if you enter the suffix value
      E
      , the input rule filters the port names that end with E or e such as empname and EMPTITLE.
    • Regular expression. To include or exclude port names that follow a certain pattern.
      For example, if you enter the value
      E.*No
      , the input rule filters port names that start with E and end with No such as ENo, EmpNo, and EmployeeNo.
  2. Select one of the following from the
    Specify by
    list:
    • Value
      . Enter the string value for the pattern.
    • Parameter
      . Create a new parameter or choose an existing parameter of string type.
  3. Specify pattern values in the
    String
    box and click
    OK
    .
  4. To create a new parameter for the pattern, perform the following steps:
    1. Click
      New
      .
    2. In the Parameters dialog box, enter a parameter name.
    3. Optionally, enter a parameter description.
    4. Enter a default value for the pattern and enter the precision value.
    5. Click
      OK
      .
  5. To choose an existing parameter for the port name, perform the following steps:
    1. Click
      Browse
      .
    2. In the Assign Parameter dialog box, choose a parameter.
    3. Optionally, create new parameters or edit parameters from this dialog box.
    4. Click
      OK
      .

0 COMMENTS

We’d like to hear from you!