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\tableLookupTo define Table Lookup rules at runtime:
- In Enterprise Designer, open a dataflow that uses the Table Lookup stage.
- Save and expose that dataflow.
- Go to Edit > Dataflow Options.
- In the Map dataflow options to stages table, expand Table Lookup. Check the box for LookupRule.
- Optional: Change the name of the options in the Option label field.
- Click OK twice.