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

Create a Dynamic Port and Define Input Rules

Create a Dynamic Port and Define Input Rules

Create a dynamic port to receive columns from the Read transformation. Define input rules to include only the string ports in the dynamic port.
  1. Drag the All Ports group from the Read_Customer_FF transformation to the All Ports group in the Exp_TRIM transformation.
    The Developer tool creates a dynamic port From_Read_CUSTOMER_FF in the Exp_TRIM transformation.
    The following image shows the dynamic port in the Exp_TRIM transformation that includes all ports from the Read transformation as generated ports:
    The mapping contains a Read transformation and an Expression transformation. The All Ports groups from the Read transformation is linked to a dynamic port in the Expression transformation. The dynamic port From_Read_CUSTOMER_FF includes all ports from the Read transformation as generated ports.
  2. Right-click the dynamic port, and select
    Edit Input Rules
    .
    The
    Input Rules
    dialog box appears.
  3. Select
    by Type
    from the
    Selection Criteria
    column.
  4. Click the
    Details
    button to select the data type you want to include.
  5. In the
    Input Rule Detail: By Type
    dialog box, select
    string
    data type from the list.
  6. Verify the
    Port Preview
    area to ensure that only string ports appear.
    The following image shows the updated input rule and the string ports in the
    Port Preview
    area of the
    Input Rule
    dialog box:
     The Input Rules dialog box for the Read_Customer_FF dynamic port has an input rule to include ports of type string. The Port Preview area lists the ports of type string. The dialog box has options to rename and reorder generated ports that are not selected.

0 COMMENTS

We’d like to hear from you!