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 3. Configure the Exp_Output Expression Transformation

Step 3. Configure the Exp_Output Expression Transformation

Add an Expression transformation Exp_Output to the mapping. Create a dynamic port to get the output ports from the Exp_TRIM transformation. Create another dynamic port to get the ports from the Read transformation and define input rules to include only the unused ports.
  1. From the Exp_TRIM transformation, drag the
    DynamicTrim
    dynamic port to the All Ports group in the Exp_Output transformation.
    The Developer tool creates a dynamic port
    DynamicTrim
    in the Exp_Output transformation.
  2. From the Read_Customer_FF transformation, drag the All Ports group to the All Ports group in the Exp_Output transformation.
    The Developer tool creates a dynamic port
    From_Read_Customer_FF
    in the Exp_Output transformation.
    The following image shows the two dynamic ports in the Exp_Output transformation.
    The mapping contains a Read transformation and two Expression transformations. The Exp_TRIM transformation has a dynamic port to receive columns from the Read transformation and a dynamic output port. The Exp_Output transformation has a dynamic port to receive columns from the dynamic output port in the Exp_TRIM transformation and another dynamic port to receive columns from the Read transformation.
  3. Right-click the From_Read_CUSTOMER_FF dynamic port, and select
    Edit Input Rules
    .
    The
    Input Rules
    dialog box appears.
  4. Click the
    New
    icon to add an input rule.
  5. Select
    Exclude
    in the
    Operator
    column.
  6. Select
    Type
    in the
    Selection Criteria
    column.
  7. Click the
    Details
    arrow to select the data type you want to include.
  8. In the
    Input Rule Detail: By Type
    dialog box, select
    string
    data type from the list.
  9. Verify the
    Port Preview
    area to ensure that string ports do not appear.
    The following image shows the updated input rule and the ports in the
    Port Preview
    area of the
    Input Rule
    dialog box:
    In the Input Rules dialog box for the From_Read_CUSTOMER_FF dynamic port, add an input rule to exclude ports of type string.

0 COMMENTS

We’d like to hear from you!