4.5.4.5 Executing DQ Groups

You can execute an approved Data quality group.

To execute a data quality group:

  1. Click Action adjacent to the DQ Group to be modified.
  2. Click Execute to access the Execute Group page.
  3. Enter/select the following details:
    • The Threshold percentage for the maximum number of errors permissible during the DQ check. By default, this is set to 100.
    • Set Fail If Threshold Breaches to TRUE, to abort the job and not include the failure records in the DQ table, when the DQ check errors are more than the set threshold value.

      If the Fail If Threshold Breaches is set to FALSE, the DQ group will be executed and the failure records will be inserted in the DQ Result tables.

    • Set Stop Insert on Threshold Breach to Y , to the stop the execution when there is a thereshold breach. The execution will be stopped even if Fail If Threshold Breaches is set to False.
    • Enter the Additional Parameters required for the Run DQ Rule filtering criteria for execution in the pattern: Key#Data type#Value; Key#Data type#Value; and so on.
    • Set the Rule Execution Connection value. By default this is set to Data.
    • Set the Result Store Connection value. By default, this is set to Data.
    • Select As of Date to execute to DQ group.
  4. After providing the required details, click Run, to begin the execution.