Go to the latest v7.6 documentation →
A provision to enable system recommend rules in a validation scenario
When an end-user ingests random sample data, the Rules Recommendation widget helps analyze the random data and applies different rules on top of it. However, the system-recommended rules are not final, and the end-user has the flexibility to modify them before validating the scenario.
Note: We can only apply 8 rules using Rules Recommendation such as Null check, Duplicate Check, Uppercase check, Lowercase check, Negative value check, Positive value check, Range check, and Domain check.
To learn more, let us walk through the below steps:
- Click the SCENARIO STUDIO module.
- Hover on the Scenario Builder snippet and click the Validation option to open it.
- From the Data Source tab, drag and drop an RDBMS Table widget and double-tap it to open.
- Read data from Table pop-up window is displayed.
- Select the Database Type and Connection Name dropdown lists and click the Navigator icon.
- A Navigator slide screen is displayed.
- Select and click the desired table from the navigator to add it under Pick Table.
- Click the Select button to save the widget.
- Click the Validation Rules tab.
- Drag and drop the Rules Recommendation widget onto the design canvas.
- A Rules Recommendation pop-up window is displayed.
Note: By default, all 8 rules are selected and displayed but the user can also unselect any rule(s) as per the requirement.
Note: By default, the Sample iterations Count and Sample Size are displayed as 3 and 1000 but the end-user can change it as per the requirement.
- Click the Recommend Rules option.
- A message Rules Recommendation in progress is displayed.
- A message Rules Recommendation Completed is displayed immediately after completing the process.
Note: These rules recommended by the system are not final and further an end-user can modify them as per the requirement.
- Click the Create Rules option to save the widget.
- A toaster message Rules Created Successfully is displayed.
- Click the Execute Now icon to execute the scenario.
- Here, the validation scenario is Failed.
- As an example, click on Domain Check – Category ID count which is 77.
- A Validations Scenario Exceptions summary page is displayed which shows all the validation execution summary.