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

Creating a Parameter Set

Creating a Parameter Set

Create a parameter set that you can use to change the runtime context for mappings and workflows.
When you create the parameter set, choose a mapping or workflow to contain the parameters. After you choose a mapping or workflow, you can manually enter parameters in the parameter set or you can select parameters.
  1. In the Object Explorer view, right-click a project and click
    New
    Parameter Set
    .
  2. Enter a name for the parameter set and click
    Finish
    .
    Enter the name of the parameter set and the repository location of the parameter set.
  3. Drag the
    Properties
    panel down and view the grid to add the parameters to the parameter set.
  4. Click
    New
    Mapping/Workflow
    .
    The Overview dialog box shows the parameter set name and description in the top panel. In the bottom panel is a grid where you can enter the Object Name, Parameter Name, Value, Type, and Path .
  5. In the
    Add Parameters
    dialog box click
    Browse
    to find the mapping or workflow that contains the parameters you need to include in the set.
    A list of mappings and workflows appears.
  6. Select a mapping or a workflow and click
    OK
    .
    A list of parameters from the mapping or workflow appears.
    The Add Parameters dialog box has a Browse button that you click to select mappings and workflows. when you select a mapping or workflow, the parameters appear in a list. Select which parameters to include in the parameter set.
  7. Select the parameters to include in the parameter set and then click
    OK
    .
    The mapping or the workflow name and the path appears in the parameter set. Each parameter that you selected appears beneath the object.
    The parameter set contains the m_Customer_Order object, the M_Minimum_Order_Parm, a default amount, and the decimal type.
  8. To add a parameter that is not yet in a workflow or mapping, right-click a mapping or object name and select
    Parameter
    insert.
    The Developer tool creates a parameter beneath the workflow or mapping. Change the parameter name, the value, and the type.
    You must add the parameter to the mapping or workflow before you use the parameter set.

0 COMMENTS

We’d like to hear from you!