For an enrichment rule, you can set a field value in a target table that is different from the source table.

As a target  table, you can only use a table that is related to the source table.

Set up the tables that you want to use as target table for the enrichment rule.

Note: On creation of an enrichment rule, automatically, the source table is added as target table.


Standard procedure

1. Click Data quality management.
2. On the Data quality policies tab, in the list, click the link of the desired data quality policy.
3. Click the Enrichment rules tab.
4. In the list, find and select the desired enrichment rule.
5. Click Target datasource.
6. Click New.
7. Select one of the available table relations of the source table.
  In the Relation name field, enter or select a value.
8. If you have selected a table relation, the related table is automatically filled.
You can select a table if you know it is related to the source table.
  In the Table name field, enter or select a value.
9. For each target datasource, other than the source datasource, you can define a dynamic query. The dynamic query defines to which target datasource records the enrichment rule applies.
  In the Query field, enter or select a value.
10. For an enrichment rule, you can use 'key-field' enrichment lines to identify records in the target datasource. The 'key-field' enrichment lines setup defines to which target datasource records the enrichment rule applies.
  Click Create key fields.
 

Note: If you do not want enrichment lines marked as key fields, you can remove the 'key-field' enrichment lines. To do so, click Remove key fields.

11. Close the page.

See also

Provide feedback