Populating Execution Statistics

This feature allows you to determine which case statement of a rule has updated how many corresponding records.

On selecting this checkbox in Others tab of System Configuration > Configuration window, an insert query is generated and executed just before the merge statement of the rule is executed. This in turn lists the number of records processed by all mappings and also stores information about Run ID, Rule ID, Task ID, Run Skey, MIS Date, number of records fetched by each mapping, order of evaluation of each mapping, and so on, in configuration table (EXE_STAT).

Typically, the insert query lists the number of records processed by each condition in the rule and is done just before the task gets executed and not after the batch execution is completed (since the state of source data might change). This insert query works on all types of query formation including Computation Rules with and without Aggregation, Classification Rules, Rules with multiple targets, Rules with default nodes, Rules with Parameters in BPs, and Rules with exclusions.