Overriding Input and Output Files

By default, a job executed in a process flow uses the input and output files defined in the job's source and sink stages. You can, however, override the input and output files defined in the job so that when the process flow runs, the job will use the input or output file you specify in the job activity in the process flow instead of the file specified in the job's source or sink stages. You can override input and output files by specifying a specific file or by using a variable to refer to a file defined in an upstream activity.

  1. Open the process flow in Spectrum Enterprise Designer.
  2. Double-click the job activity for which you want to override an input or output file.
  3. Click the Variables tab.

    On the Variables tab, the variables listed under Inputs correspond to the source stages in the job. The variables listed under Outputs correspond to the sink stages in the job.

    For example, say you have a process flow that contains a job activity for a job named MyGeocodingJob. On the Variables tab of the activity options you see this:

    Each variable listed corresponds to the name of a source or sink stage in the MyGeocodingJob dataflow. In this example the Variables tab shows one source (Read from File) and two sinks (Write Failed and Write Successful). If you were to open up the MyGeocodingJob dataflow in Spectrum Enterprise Designer, you would see something like this:

  4. On the Variables tab, select the source stage or output stage that you want to override and click Modify.
  5. the Location field, choose one of the following to override an input or output file.
    To override an input file:
    Choose thisTo
    Use file specified in job Use the file defined in the source stage in the job.
    Browse for file on the server Override the file defined in the job and use a different file that you choose.
    Reference an upstream activity's file Override the file defined in the job with a file whose name and location is defined in an upstream activity's Read from File or Write to File stage or an upstream activity's variable. Use this option if the output file from a previous activity is the input for this activity. The advantage of this option is that if the upstream activity's Write to File stage is ever modified to point to another file, this activity will still point to the correct file. Another advantage is that you do not need to know the file path and name of upstream activities' input file to point to it.
    To override an output file:
    Choose thisTo
    Browse for file on the server Override the file defined in the job and use a different file that you choose.
    Temporary file managed by the server Make this variable reference a temporary file that will be automatically created and deleted as needed. This option is useful in cases where a file used only as an intermediate step in a process flow and is not needed once the process flow completes.
  6. Click OK to close the Modify Variable window.
  7. Click OK to close the activity options window.

When the process flow runs, the job will use the files you specified in the process flow activity instead of the file specified in the job itself.