Adding Parameter Definition

  1. Click in the Parameter Definition pane. A new row is inserted and allows you to define the run-time parameters to the transformation.
  2. Enter the parameter name.
  3. Click the Data Type cell and select the required Data Type from the list by using the List icon .The supported data types are Integer, Decimal, Number, Char, Varchar2, and Date.
  4. Double-click the Default Value cell and enter the default value for the parameter.
    You can add more parameters by inserting additional rows and entering appropriate details. To edit Parameter Name or Default Value, double-click the required cell and edit the values.
    Additionally, you can delete a parameter by selecting the row and clicking the Delete icon.