When you perform a data subset operation, the task can return the number of target subset rows that is more than the applied filter criteria.
When you run a data subset operation, the task selects the records in an object based on the filter criteria. The filtered records of the object can contain child records. The child records might have references to other records from the same parent object. In such cases, the task loads additional records along with filtered record to maintain referential integrity.
Data subset rows example
Consider that there are Account, Case, and Contact objects. Account is the parent object, and Case and Contact are the child objects of Account. The Contact object is also parent to the Case object.
The following image shows the source objects and related objects:
The following table shows the two sample cases and the respective contacts for the account ABC1:
Case
Contact
00002541
Victor
00002542
Jack
Apply a subset filter on the Account object to load the target with ABC1 accounts. When you run the masking task, the task first applies filter on the account to load ABC1. The account ABC1 contains case 00002541 and case 00002542. If you enable the child record selection from the Account object to the Case object, the task loads case 00002542 and case 00002541.
The case 00002541 refers to the contact Victor, and the case 00002542 refers to the contact Jack. The parent account of Jack is XYZ2. To maintain the referential integrity for the contact Jack with the case 00002542, the task loads the additional XYZ2 account. Though you applied filter to load the account ABC1, the task loads both ABC1 and XYZ2 acounts.
The task loads six subset rows, two rows from each Account, Contact, and Case object.
The following image shows the masking task activity log entries for a data subset operation:
