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 5. Bind Mapping Outputs to Mapping Parameters

Step 5. Bind Mapping Outputs to Mapping Parameters

Bind the mapping output to the configured mapping parameter.
  1. Click the editor to access the mapping properties.
  2. Open the
    Parameters
    view.
  3. For the parameter col_id_val that you defined to accept the persisted mapping output, use the drop down menu in the
    Binding
    column to select the mapping output Output_ID.
On subsequent runs of the mapping, the persisted value for Output_ID will be passed to the mapping parameter col_id_val. The following image shows the mapping parameters: The Parameters view shows the two mapping parameters col_id_val and col_id_name. The parameter col_id_val has the type double, precision set to 15, scale set to 0, default value set to 0.0, and binding set to Output_ID.

0 COMMENTS

We’d like to hear from you!