6.1 Add Step Wizard

Use to add a step to a Load Plan.

How?

The Add Step Wizard has the following steps that vary depending on the type of step you are adding:

6.1.1 Step 1 - Select a type and location of the step

Use to specify the step type and the location of the step.

Properties Description
Step Type Type of step that is added. Possible step types are: Serial, Parallel, Run Scenario, Case, When, Else, and Exception if you start the Add Step Wizard from the Exception tab. See "Load Plan Structure" for more information on the different step types.
Step Location This parameter defines where the step is added.
  • Add a child step to selection: The step is added under the selected step.

  • Add a sibling step after selection: The step is added on the same level after the selected step.

  • Add a sibling step before selection: The step is added on the same level before the selected step.


Note:

Only values that are valid for the current selection are displayed for Step Type and Step Location.

Click Next to move to the next step of the Add Step Wizard.

6.1.2 Step 2 - Select Step Name (for Serial, Parallel, Else, and Exception steps)

Use to specify the name of the Load Plan step.

Enter a Step Name for the new Load Plan step.

Click Finish to complete the Add Step Wizard and add a new Load Plan step.

6.1.3 Step 2 - Select Scenario (for Run Scenario steps)

Use to select the scenario you want to add to your Load Plan.

Click Lookup Scenario to select the scenario.

The Step Name is automatically populated with the name of the scenario and the Version field with the version number of the scenario. The Step Name is editable and you can change it.

Tip:

At design time, you may want to create a Run Scenario step using a scenario that does not exist. In this case, instead of selecting an existing scenario, enter a Scenario Name and Version directly and click Finish. Later, you can select the scenario using the Modify Run Scenario Step 1 wizard.

Note that when you use the version number -1, the latest version of the scenario is used.

Click Next to move to the next step of the Add Step Wizard.

6.1.4 Step 2 - Select Variable to Evaluate (for Case steps)

Use to select the variable to evaluate.

Properties Description
Variable Variable to use for the conditional branching.
Note:
You can either select one of the Load Plan variables from the list or click Lookup Variable to add a new variable to the load plan and use it for this case step.

See "Working with Variables" for more information.

Step Name The Step Name is automatically populated with the step type and name of the variable. The Step Name is editable and you can change it.

Click Finish to complete the Add Step Wizard and add a new Load Plan step.

6.1.5 Step 2 - When Clause Evaluation (for When steps)

Use to define the When clause.

Properties Description
Operator Operator to use in the WHEN clause evaluation. Possible values are:
  • Less Than (<)

  • Less Than or Equal (<=)

  • Different (<>)

  • Equals (=)

  • Greater Than (>)

  • Greater Than or Equal (>=)

  • Is not Null

  • Is Null

Value Value to use in the WHEN clause evaluation.
Step Name The Step Name is automatically populated with the operator that is used. The Step Name is editable and you can change it.

Click Finish to complete the Add Step Wizard and add a new Load Plan step.

6.1.6 Step 3 - Select Scenario Variables (for Run Scenario steps)

Use to select variables that will be added to the Load Plan step.

In the Add to Load Plan column, select the scenario variables that you want to add to the Load Plan variables. If the scenario uses certain variables as its startup parameters, they are automatically added to the Load Plan variables.

Click Finish to complete the Add Step Wizard and add a new Load Plan step.

"Adding Load Plan Steps" in the "Creating a Load Plan" chapter in Oracle Fusion Middleware Developing Integration Projects with Oracle Data Integrator