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.
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_TRG data models.