Configuring Options at Runtime

Table Lookup options can be configured and passed at runtime if they are exposed as dataflow options. This enables you to override the existing configuration with JSON-formatted strings. You can also set stage options when calling the job through a process flow or through the job executor command-line tool.

You can find a schema for LookupRule in the following folder:

<Spectrum Location>\server\modules\jsonSchemas\tableLookup

To define Table Lookup rules at runtime:

  1. In Enterprise Designer, open a dataflow that uses the Table Lookup stage.
  2. Save and expose that dataflow.
  3. Go to Edit > Dataflow Options.
  4. In the Map dataflow options to stages table, expand Table Lookup. Check the box for LookupRule.
  5. Optional: Change the name of the options in the Option label field.
  6. Click OK twice.