Rules

On the Rules tab you can create the conversion rules between the source table(s) fields and the target table(s) fields. You can use Function Builder to apply the function to the conversion rule details. Documentation text can be maintained for mapping rule details.

When you switch from the Condition tab to the Rules tab for the multiple target tables conversion object and also when multiple dumps are declared in the Main Query, Dump No and Target Table then the mapping dialog box is displayed. Dump No and Target Table mapping is a one time task. After you define the Dump No and Target Table mapping, the default ( ) value is stored in the first field of the respective dump. This value can be changed later, but if the first field value is left blank, then for that dump no target table mapping must be done again next time.

Related topics

- Condition tab of Open Conversion Object detail page.

Fields | Description
Dump No | Select the Dump No to see the source table fields in the select query given in the Main Query field of the Condition tab. In the Condition tab, if a comment is made on the dump statement, the comment also displays here along with the dump number. Note Click Show after you select the dump number, to reflect the source table fields that are part of dump in the Source Fields control.
Change | Changes the target table attached to the current Dump No. Note This button is shown only if the conversion object is the multiple target tables conversion object.
Target Fields | The target table field details. Following details are shown: Field No. Field Name Type Length Description Alignment Case Domain Note Fields marked with an asterisk (*) are mandatory value fields.
Source Fields | The source table field details. Following details are shown: Field No Field Name Type Length Description Alignment Case Domain Note Fields marked with an asterisk (*) are mandatory value fields.
Details | The conversion rules details for each target table field.

Commands | Description
Map | Creates the conversion rule between the selected target field and source table field.
Edit Rule | Edits the selected conversion rule details text in the editor application at the user details level.
Build | Starts the function builder in a separate window .
Text | Maintains the documentation text in a separate window for the selected target table field in the Details group box, for which mapping is done. Field rule documentation text is divided into the following sections:
Section | Target Group | Section Description
--- | --- | ---
Field Mapping | User | In complex situations: explain the logic used to fill the target field data. Use the functional field names in the text. This section is empty for most of the field rules.
Technical Notes | Programmer | Technical design can be specified. This section is empty for most of the field rules.
Guess | Click this button to guess the conversion rules between target table fields and source table fields. The Guess functionality will not change existing conversion rules but only completes the conversion rules if the field rule is empty. If the Guess function cannot determine a match between target and source field the conversion rule will be filled with default(). Mapping of conversion rules is done in the following order: For each field in the target table, it searches the first source field with the exact matching table name and field name. If this search is not successful, then it searches the first field with the exact matching field name in any of the selected source tables. In case either of the search is successful, then the conversion rule is added as target table field=first source table field with the matching field name. If the field with exact name is not found in the source table, then it searches for the field with the same domain in the source table. If found, the conversion rule is added as target table field=first source table field with the matching domain. If the field with the same domain is also not found in the source table, it checks whether the target table field takes a default value. If yes, the conversion rule is added as target table field=0. During the script generation, if it finds a target field without any value, it will check whether any initial value is defined at a table level. If it finds any initial value, it will assign the initial value, else will assign 0 for numeric type fields and blank space for string type fields. If the target field is of type UTC and the source field is of type Date or UTC then the conversion rules takes the UTC conversion into account. Note The conversion rules added using the Guess functionality requires fine-tuning and validation.
Copy from Dump | Copies the field mapping rules from other dump no maintained before. After you click this button, it will ask you the dump no from where you want to copy the field mapping rules.
Save | Saves the changes made, before you activate the Condition tab.
Done | Click Done to return to the Maintain Conversion Objects page.
Cancel | Cancels the current operation and opens the Maintain Conversion Objects page.

| Send Us Your Feedback About this Help Page