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.
Consider the following scenario where, a typical rule would contain a series of Hierarchy Nodes (BI/Non BI) as Source and one or more BPs or BI Hierarchy Leaf Nodes in the Target.
Rule 1 consists of the following:
|
SOURCE |
TARGET |
|
Condition 1 |
Target 1 |
|
Condition 2 |
Target 1 |
|
Condition 3 |
Target 1 |
|
Condition 4 |
Target 2 |
The insert query execution populates execution statistics based on the following:
· Each rule has processed at least one record.
· Each target in the rule has processed at least one record through Condition 1 / Condition 2 / Condition 3 and Condition 4.
· Each source in the rule has processed at least one record through Condition 1 / Condition 2 / Condition 3 and Condition 4.