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

Resolving and Validating Parameters

Resolving and Validating Parameters

You can resolve and validate mapping parameters to ensure that the Data Integration Service can read and process the parameters at run time. The mapping must be valid before you resolve the parameters. When you resolve the mapping parameters, the Developer tool generates an instance of the mapping that shows how the Data Integration Service resolves the parameters at run time.
If you run a mapping multiple times using different parameter sets or parameter files, validate the mapping with resolved parameters each time to make sure that the parameter sets or parameter files are compatible with the mapping.
  1. In the Developer tool, right-click a mapping in the editor or the Object Explorer view. Select
    Show Mapping with Resolved Parameters
    .
    The
    Show Mapping with Resolved Parameters
    dialog box appears.
    This dialog box shows the options that you can use to resolve mapping parameters. You can select to resolve the parameters using the default values in the mapping, a parameter set, or a parameter file.
  2. 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.
  3. Click
    OK
    .
    The Developer tool generates a run-time instance of the mapping that shows the resolved parameters. The run-time instance of the mapping appears in a new tab.
  4. Right-click the run-time instance of the mapping and select
    Validate
    .
    If errors appear in the
    Validation Log
    view, fix the errors and validate the mapping again.
  5. To run the mapping with the selected parameters, right-click the run-time instance of the mapping and click
    Run
    .

0 COMMENTS

We’d like to hear from you!