Translation Rule Actions - Two-tier Access Path
A translation rule action with a two-tier access path is used when the replacement row must be selected from within the translate table rows that match the source value used to search. For example, a tier-one value for state could be used for accessing addresses only within that state. When this access path is used, the tier-one value is searched for and then tier-two access is used to select, from the returned rows, a row to use as the replacement row.
To add a translation rule action:
- Open the desired repository and project.
- Click the Rules tab, and select the desired rule. The list of existing rule actions for that rule appears in the Rule Action tab portion of the window.
- To add a new rule action, click Add. The Create Rule Action wizard appears.
- Select Translation and click Next.
- Type a Name or keep the default name for your rule action. You can have more than one rule action per rule, but each rule action name must be unique within the rule.
- Select the desired translate table from the list. The list of available translate table data is displayed for Translate Table Properties.
- Select the desired access path from the list. The access path is set up at the time the translate table is created. When a Two-tier access path is selected, the tier-one search data is added to the Translate Table Properties.
- Click Next. The Search Translation Rule Action window appears.
From the Search Access Path Data, select the desired data. From the Project Resource list, select the data element or variable from the list that corresponds to the Search data, and enter a field mask, if desired.
There are three types of tier-two access: Hash source value, sequential row selection, and random row selection. Continue with the section below that corresponds to the type of tier-two access being used.
Hash Source Value Tier-two Access
- Click Next. The Hash Translation Rule Action window appears.
From the Project Resource list, select a data element or variable for the hash, and enter a field mask, if desired.
- Click Next. The Map Replacement Values window appears.
From the Project Resource list, select the elements and variables to be replaced with data from the translate table. Select a Translate Table Data for each Project Resource you select. Enter a field mask, if desired.
When the selected project resource is a data element, the Identify column will automatically be set to Required to indicate that this data element must be present in the metadata for the rule to be selected. Optionally, click on Required to indicate that the data element is optional. The rule will be applied if all of the required data elements are present and any of the optional fields. If all the fields are marked as optional, the rule will be selected if any of the optional fields are present.
- Click Finish. The translation rule action will now appear in the Rule Actions list for the selected rule.
Sequential Row Selection Tier-two Access
- Click Next. The Sequential Translation Rule Action window appears.
- If each row of the translate table should only be returned once, select Unique row retrieval required.
- Click Next. The Map Replacement Values window appears.
From the Project Resource list, select the elements and variables to be replaced with data from the translate table. Select a Translate Table Data for each Project Resource you select. Enter a field mask, if desired.
When the selected project resource is a data element, the Identify column will automatically be set to Required to indicate that this data element must be present in the metadata for the rule to be selected. Optionally, click on Required to indicate that the data element is optional. The rule will be applied if all of the required data elements are present and any of the optional fields. If all the fields are marked as optional, the rule will be selected if any of the optional fields are present.
- Click Finish. The translation rule action will now appear in the Rule Actions list for the selected rule.
Random Row Selection Tier-two Access
- Click Next. The Random Translation Rule Action window appears.
- Select whether you want each row of the translate table to be used only once (Unique row retrieval required), and/or enter a Seed value for random calculation. You can also select whether to use a cryptographically strong random number generator that produces non-deterministic output (Use secure random). If you enter a seed number, non-secure random generation will be repeatable. Secure random generation, however, will not be repeatable even when a seed value is entered.
- If desired, select Seed value for random calculation and type a value in the adjacent field.
- Click Next. The Map Replacement Values window appears.
From the Project Resource list, select the elements and variables to be replaced with data from the translate table. Select a Translate Table Data for each Project Resource you select. Enter a field mask, if desired.
When the selected project resource is a data element, the Identify column will automatically be set to Required to indicate that this data element must be present in the metadata for the rule to be selected. Optionally, click on Required to indicate that the data element is optional. The rule will be applied if all of the required data elements are present and any of the optional fields. If all the fields are marked as optional, the rule will be selected if any of the optional fields are present.
- Click Finish. The translation rule action will now appear in the Rule Actions list for the selected rule.
Related Topics
Create-Two-tier-Access-Path-Definition