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

Parameter Files

Parameter Files

A parameter file is an XML file that lists user-defined parameters and their assigned values. Parameter files provide the flexibility to change parameter values each time you run a
mapping
.
The parameter values define properties for a mapping. The Data Integration Service applies these values when you run a mapping and specify a parameter file.
You can define mapping parameters and workflow parameters in a parameter file. If you want to specify reusable object parameters, expose the reusable object parameters as mapping parameters. Specify the mapping parameter values in the parameter file.
You cannot define system parameter values in a parameter file.
You can define parameters for multiple
mapping
s in a single parameter file. You can also create multiple parameter files and then use a different file each time you run a
mapping
. The Data Integration Service reads the parameter file at the start of the
mapping
run to resolve the parameters.
You can export a parameter file from the Developer tool. Export the file from the mapping or the workflow
Parameters
tab. The Developer tool generates a parameter file that contains the mapping or workflow parameters and the default parameter values. You can specify the parameter file name and choose where to save the file.
Parameter files for mappings and workflows use the same structure. You can define parameters for deployed mappings and for deployed workflows in a single parameter file.
You can also list the parameters and default values used in a
mapping
from the command line. You can use the command line output as a parameter file template.
Run a mapping with a parameter file from the Developer tool or run the mapping from the command line.

0 COMMENTS

We’d like to hear from you!