Defining Parameters

Use the Parameters tab to specify the list of parameters for a ODI Scenario. The parameter definition includes a non-translated parameter name and a translated prompt. The prompt is used for display in the data rule page.

This section includes information on:

Adding Parameters

When you add a parameter for the source adapter, definition is created which includes a non-translated parameter name and a translated prompt.

  To add a source column:

  1. In the Tasks pane, under Setup, select Source Adapter.

    The Source Adapter screen is displayed.

  2. Select the Parameters tab.

  3. From the Parameters task bar, select Add.

    Entry fields appear for the Parameter Name, Parameter Data Type, and Parameter Prompt columns.

  4. In Parameter Name, enter the parameter name.

    For example, enter “p_actual_flag”. This is the name of the parameter in the ODI project.

  5. In the Parameter Data Type drop-down, select the data type of the parameter:

    • Char

    • Number

    • Date

  6. In Parameter Prompt, enter the parameter prompt.

    For example, you might enter “Balance Type” in this row.

    Note:

    When a new parameter is added and you are in a multi-language environment, then set the browser locale to the appropriate language and edit the prompts as needed in that language.

Deleting Parameters

  To delete a parameter:

  1. In the Tasks pane, under Setup, select Source Adapter.

    The Source Adapter screen is displayed.

  2. Select the Parameters tab.

  3. From the Parameters task bar, select the parameter and click Delete.

    The Delete Source Adapter Parameter screen is displayed.

  4. Click OK.