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

How to Run a Mapping Using Advanced Options

How to Run a Mapping Using Advanced Options

To run a mapping using advanced options, run the mapping through the
Run Mapping Using Advanced Options
dialog box. Select a mapping configuration or create a custom mapping configuration, and specify the mapping parameters. The mapping configuration and mapping parameters that you specify persist for the current mapping run.
If you use advanced options to run a mapping instance where the parameters are resolved, you cannot specify mapping 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. Optional. If the mapping contains parameters, you can select one of the following parameter 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!