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

Advanced Mapping Options

Advanced Mapping Options

You can run a mapping in the Developer tool using advanced options. The advanced mapping options include mappings configuration options and mapping parameter options.
Specify the mapping configuration and mapping parameters each time that you run the mapping. Select a reusable mapping configuration or customize the mapping configuration that you use when you run the mapping. Use the default parameter values in the mapping or use parameter values in a parameter set or a parameter file. 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.
The following table describes the options that you use to specify a mapping configuration:
Option
Description
Select a mapping configuration
Select a mapping configuration from the drop-down menu. To create a new mapping configuration, select New Configuration.
Specify a custom mapping configuration
Create a custom mapping configuration that persists for the current mapping run.
The following table describes the properties that you configure when you specify a custom mapping configuration:
Property
Description
Use the default Data Integration Service
Uses the default Data Integration Service to run the mapping.
Default is enabled.
Data Integration Service
Specifies the Data Integration Service that runs the mapping if you do not use the default Data Integration Service.
Available operating system profiles
Specifies the operating system profile to run the mapping when the Data Integration Service is enabled to use operating system profiles.
Override tracing level
Overrides the tracing level for each transformation in the mapping. The tracing level determines the amount of information that the Data Integration Service sends to the mapping log files.
Optimizer level
Controls the optimization methods that the Data Integration Service applies to a mapping.
The following table describes the options that you use to specify mapping parameters:
Mapping Parameters
Description
Apply the default values in the mapping
Resolves the mapping parameters based on the default values configured for the parameters in the mapping. If parameters are not configured for the mapping, no parameters are resolved in the mapping.
Apply a parameter set
Resolves the mapping parameters based on the parameter values defined in the specified parameter set.
Apply a parameter file
Resolves the mapping parameters based on the parameter values defined in the specified parameter file.
If the mapping does not contain parameters, the option to specify mapping parameters is disabled.

0 COMMENTS

We’d like to hear from you!