Translation Rule Actions - Random Access Path
A translation rule action with a random access path is used when the row number to select from the translate table is determined by calculating a random number at rule execution time.
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.
- 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. If you enter a seed number, you will get the same random sequence each time you use that number.
- 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 Action list for the selected rule.
Related Topics
Create-Random-Access-Path-Definition