Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Data subset rows example

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 Source Details section displays the Account, Case, and Contact source objects with the relationship details.
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:
The job details shows the activity log entires for a data subset operation in a masking task.

0 COMMENTS

We’d like to hear from you!