Passing start-up parameters to a scenario using variables
One of the most popular methods of affecting the behavior of an ODI scenario is to pass in parameter values at execution time. Whether launching a scenario from the GUI, the command line, or from a web service, the use of parameter values is a simple yet effective way of controlling a scenario's activities. In this recipe, we will design a workflow to include a start-up parameter in order to pass in a specific value at execution time.
Getting ready
This recipe will create a simple interface that will require the following KM: IKM – SQL Control Append. Be sure to import this KM into your project. Also, be sure to reverse engineer the
DEMO_SRC and
DEMO_TRG data models.
How to do it...
Within your project, insert a new Variable called
PV_DATE_FILTER(note that you may have already created this variable in a previous recipe).Select the Data type option as
Alphanumeric, since it will be easier for us to manipulate and pass the value around...
