Setting the join keys elements for a data rule

When you set the bindings and output for a data rule, you create a direct link between a conceptual element in a rule definition, and a physical piece of data in one of your data sources. If you want to use data from more than one table, then you need to set join key elements as part of the binding process.

1. Open the data rule you want to set the join key elements for from the Data Quality workspace.
2. Find the Overview and Binding And Output tabs on the top of the screen, and click on the Binding and Output tab.
3. In the Select View menu on the left side of the screen, click on Bindings and fill out the appropriate information in the Rule Logic Variables box to bind your data rule to the appropriate physical data elements.
4. In the Select View menu, click Join Keys. The Join Keys workspace displays a Tables Requiring Joins table that shows the tables that you need to join.
5. Use the Tabbed Palette on the right side of the screen to define Key 1 and Key 2. Click the Data Sources tab and select a key from a specific table in your data sources. Select the Show tables from Bindings Only box if you want to select only keys from tables that you set in your binding settings. You can search your volumes of tables by using the search box on top of the Data Sources tab. Use the arrows to the right of the search box to jump to the next piece of data that matches your search criteria.
6. Specify the join type by selecting from the Include Records menu.
7. Optional: Validate the join settings by clicking the Validate button, and running the data rule with the new join settings by clicking Run. You can view the output of the data rule by clicking View Output.
8. Click Saveto save your current settings or click Save and Close if you have finished working with this data rule.