Schema is defined as the set of rules grouped together to perform on same set of data. Schema framework in MDO can be used to apply governance rules on already existing data to identify inconsistent data. This Comprehensive Schema framework makes us the perfect partner to handle your end to end data transformation projects.
Configuring Schema Rules
In order to configure the schema rules, please follow the below mentioned steps:
- Login with Business Administrator credentials.
- Click on setting icon on top right corner and Click “Modules”
- Select a module from the list for which you want to configure schema rules.
- Click on “Business Rules” tab and select “Schema”
- Click on ‘‘Add New’’ to add a new schema.
- Fill the required information as stated in the table provided below:
|Category *||Select the schema category from the defined set: MRO Cleansing, Duplicacy, Data Quality or Data Transformation.|
|Name *||Enter the description of the schema rule.|
|Owner Type *||Allows you to select the user(s)/role(s) to which the schema notifications should be sent.|
|Structure *||Select the structure on which the schema will run. E.g., Header Information.|
|Plant Code *||Enter the plant code/Tenant ID of the company.|
|Label||Allows you to change the label for Success, Error and Total as per the requirement.|
- Click “Save” to save the schema.
- Now Go to “Details” in front of the schema that has been configured.
- Click on “Add Business Rule” to add a new schema rule. User can configure different type of rules which are described as below:
- Dependency: This rule establishes a dependency relationship between source and target fields.
- API: This rule is used to define any complex custom logic to validate/transform target fields using API framework.
- Duplicacy Check: This rule helps you to identify the duplicates records based on matching field combinations.
- Metadata Rule: This rule is to check metadata properties like data type, length, predefined formats etc.
- Missing Rule: It helps you identify the fields which does not contains any value.
- Regex: This rule helps you to check accuracy of field value through regular expression (Regex).
- User Defined Rule: Define readable conditions to validate/transform the field values.
- Lookup Table: This rule helps you to validate/transform target value-based mapping defined in the Lookup tables.
- Query Rule: This rule helps you to validate values based on mapping fields defined in the Query.
- Click on “Next” after selecting the rule.
- Enter the description and select the category to which the rule belongs to.
- Select the field on which the rule is applied. Write the message which needs to be displayed. Then click on “Finish” to save the rule.
One can also refer the rules created from the other schemas. Please follow the below steps in order to add an existing Business Rule(s):
- Click on “Add Existing Business Rule(s)”. Select the required rules.
- Click on “Assign” to add selected rules to the schema.
- Click on “Activate” to activate the rules.
Adding weightages to the schema rules
Weightage defines how important a rule is to the business. It is assigned to each rule to access the total health of a record in data quality workbench.
In order to specify weights to the rules, follow the below steps:
- Click on “Define Weightage”.
- Specify weightages to the rules by clicking on “Edit”.
- Click on “Back” to exit the weightage page.
Schema list page configuration
In order to configure the list page, follow the below mentioned steps:
- Click on “List Page” in front of the schema.
- Search for the fields which needs to be added to the list page.
- Add all the required fields.