Adding Parameters

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

To add a source column:

  1. On the Setup tab, under Register, select Source Adapter.
  2. In Source Adapter, select the Parameters tab.
  3. From the Parameters task bar, select Add.

    Entry fields are displayed 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 Parameter Data Type, select the data type of the parameter:
    • Char

    • Number

    • Date

  6. In Parameter Prompt, enter the parameter prompt.

    For example, 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.