3.5.4 Adding a DQ Check Task

You can add a new DQ check Task in the Scheduler Services and add the task to a Batch Definition, for execution.

For more information about adding a task to the Batch and about Scheduler Services, refer to Scheduler Services Documentation.

To add new task using the Define Tasks page in Scheduler Services, perform the following steps:

1. Click Define Tasks from the Header panel.
2. Select the Batch, to add new task.
3. Click Add, to add a new DQ task in the Create Task page.
   • Complete all the generic details in the Create Task Page. For more information refer to Create Task Using Scheduler Services.
   • Select the Task Type as DQ Task.
   • Select the Group to perform the DQ check.
   • Enter the Threshold percentage for the maximum number of errors permissible during the DQ check. By default this value 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 job will proceed further and the failure records will be inserted in the DQ Result tables.

   • 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.
4. Click Save to add the new DQ task to the selected Batch.