Go to the latest v7.6 documentation →
Enable rule recommendation in Bulk Data Validation
Previously, the end user had to apply different validation rules manually for each selected field or column but now the system recommends rules for all the selected fields. The end user must either select all or specific rules before applying the rules recommendation option.
Note: Currently, the scope of recommending rules in BDV is applicable to MSSQL, MYSQL, Redshift, and Oracle profiles only.w
To learn more, let us walk through the below procedure:
- Click the SCENARIO STUDIO module.
- Hover on the Scenario Builder snippet and click the Bulk Data Validation.
- A Bulk Data Validation session page is displayed.
- Select the required profile from the profile drop-down list.
Note: Object Selection and Query Selection options are displayed immediately after profile selection.
Note: Currently, we can use rules recommendation only using Object Selection option.
- Select the required Database and Schema drop-down lists and click the Get Metadata option.
- This action displays the Metadata on the right screen.
Note: By default, all the tables are selected.
Select the required tables and click the Recommend Rules option.
- A Rules Recommendation pop-up window is displayed.
Note: By default, all the rule types are selected. We can select the required rules as per the requirement.
Note: By default, Sample Iterations Count, Sample Size, and Parallelism are selected.
- Click the Recommend Rules option.
- This action initiates the process of recommending rules as shown in the below screenshot.
- All the rules are configured based on the system recommendation.
Note: Before executing the scenario, the users have the provision to edit any rules based on the requirement.
- Click the Save icon.
- A Save Bulk Validation Scenario pop-up window is displayed.
- Add the Scenario Name, select the Folder Path, and click the Save option to save the scenario.
- A toaster message Scenario Saved Successfully is displayed.
- Click the Execute Now icon.
This action executes the BDV scenario displaying the Summary details.
Here the scenario is Failed.
Click the Details tab.
- This action displays the execution details in a grid pattern.