Data Validation Option Best Practices

Data Validation Option Best Practices

Target Folder Setup for Users

Target Folder Setup for Users

Each Data Validation Option user can be assigned their own target folder in the target PowerCenter repository. Having separate target folders will help organize the Data Validation Option generated metadata and allows for easier maintenance.
For example, when an employee leaves the company, that employee's target folder can be purged without impacting other users.
On the other hand, if multiple users share the same target folder, it is nearly impossible to determine which objects are owned by different users. Additionally, in highly active Data Validation Option environments, multiple users might import the same objects at the same time. This causes the test for one user to fail with a PowerCenter locking error message.

0 COMMENTS

We’d like to hear from you!