The Data Masker Create/Edit Row-Internal Synchronization Rule Form
This form is used to create and edit Data Masker Row-Internal Synchronization rules. Row-Internal Synchronization rules are designed to update a specified column in a row with a combination of values from other named columns within the same row. Values from datasets can also be used as replacement data. The title text and button label on the form will change as is appropriate to the create or edit mode. In the example screen shot above, the form is editing an existing Row-Internal Synchronization rule.
A Row-Internal Synchronization rule must be configured with a target table and column name and some SQL code (called a Replacement Clause) which constructs the new values for each row in the target column. The construction of a replacement clause is similar to that which would be used in a conventional SQL UPDATE statement. In the example above, the EMP_ID field is being built with a concatenation of the first three letters of the LAST_NAME column and a numeric value supplied from the Numbers, Integers, (Random As Text) dataset.
Configuring the target table and column is a straightforward process. Use the mouse to select the table and column from the Table and Column tab. The choice of available tables is entirely determined by the Rule Controller with which the Row-Internal Synchronization rule is associated. Only tables from within the schema for which the Rule Controller is configured will be visible. If you do not see the tables you require, the schema structure can be refreshed using the Refresh Schema and Indexes button on Options tab of the edit Rule Controller form.
The Replacement Clause is entered in the lower right hand panel. It is structured as a SQL Clause and can reference the other columns in the row by name or use the DMOPARAM pseudo column to reference values from the datasets. The Row-Internal Synchronization rule help file discusses these concepts in detail.
During execution, as the Row-Internal Synchronization rule processes each row, the generated replacement values will be substituted in place of the existing data in those columns. The Row-Internal Synchronization rules help file has more information and examples. Note: it is not always necessary to reference column values from within the row in the Replacement Clause. It is possible to call a previously defined function or stored procedure. A Command rule can be used to create the function or stored procedure if necessary.
WHERE Clause and Sampling options are used when the choice of rows affected by the synchronization operation is to be based on a specific criteria. WHERE Clause and sampling options are configured on the WHERE Clause tab.
Existing Row-Internal Synchronization rules can be edited by double clicking on them with the mouse. Row-Internal Synchronization rules are created by launching the New Row-Internal Synchronization rule form using the New Rule button located on the bottom of the Rules in Set tab.
