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

Configuring Dynamic Ports Using Input Rules

Configuring Dynamic Ports Using Input Rules

Define input rules to specify which ports to generate and propagate through a dynamic port in the pipeline.
Use the
Input Rules
dialog box to define input rules for a dynamic port, rename the generated ports to indicate where ports occur in a mapping, change the order of the generated ports, and view the results for the rules. You can add multiple rules to include and exclude ports. The Data Integration Service applies rules in the order that they appear in the list.
  1. Open the Input Rules dialog box.
  2. Define one or more input rules for each dynamic port in the transformation. For each input rule, perform the following steps:
    1. Choose the operator and the selection criteria for the input rule.
    2. If you choose the Name selection criteria, specify the criteria details by name or by parameter.
    3. If you choose the Type selection criteria, select the data type of the ports from the list.
    4. If you choose the Pattern selection criteria, select the pattern type, and specify the pattern string as value or as paramter.
    Optionally, define the input rule for the last dynamic port in the transformation to include all remaining ports from the upstream transformation.
  3. Rename the generated ports.
  4. Optionally, reorder the generated ports.
  5. Verify the results of the input rules and the input rule settings.

0 COMMENTS

We’d like to hear from you!