Configuring Options at Runtime - dataflow_designer - spectrum_quality_1 - 23.1

Spectrum Data Quality Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Quality > Spectrum Quality
Version
23.1
Language
English
Product name
Spectrum Data Quality
Title
Spectrum Data Quality Guide
Topic type
Overview
Reference
Tips
How Do I
First publish date
2007
ft:lastEdition
2024-03-04
ft:lastPublication
2024-03-04T22:52:13.486265

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.