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

Running a Mapping with Parameters

Running a Mapping with Parameters

To run a mapping with parameters from the Developer tool, run the mapping using advanced options. In the Developer tool, you can run a mapping using the default parameter values in the mapping, a parameter set, or a parameter file.
If you run a mapping instance where the parameters are resolved, you cannot specify different parameters to run the mapping. The mapping runs using the parameters that are resolved in the mapping.
  1. In the Developer tool, right-click a mapping in the editor or the Object Explorer view. Select
    Run Mapping Using Advanced Options
    .
    The
    Run Mapping Using Advanced Options
    dialog box appears.
    This dialog box show advanced options to run a mapping in the Developer tool. At the top, there is a pane for Mapping Configurations. At the bottom, there is a pane for Mapping Parameters. To specify mapping configurations, you have options to select a mapping configuration or specify a custom mapping configuration. To specify mapping parameters, you have options to select the default values in the mapping, to apply a parameter set, or to apply a parameter file.
  2. Select one of the following mapping configuration options:
    • Select a mapping configuration. Choose a reusable mapping configuration to run the mapping.
    • Specify a custom mapping configuration. Select the Data Integration Service, operating system profile, override tracing level, and optimizer level.
  3. Select one of the following mapping parameters options:
    • Apply the default values in the mapping. The Data Integration Service applies the default parameter values configured in the mapping.
    • Apply a parameter set. The Data Integration Service applies the parameter values configured in the parameter set.
    • Apply a parameter file. The Data Integration Service applies the parameter values configured in the parameter file.

0 COMMENTS

We’d like to hear from you!