When metadata (source and target definitions and connection information) are imported from multiple PowerCenter repositories into a single Data Validation Option repository, there is the potential for metadata collision.

The collision could be from duplicate source or target names, or duplicate connection names across the repositories. For source or targets definitions, duplicate names do not necessarily mean duplicate definitions because the full path from the source repository is carried forward into the Data Validation Option repository. But, users who are not careful may choose the wrong source or target by not reading the full path and name and thus inadvertently introduce errors in their tests.

Additionally, a given PowerCenter repository can contain hundreds of connections and thousands of sources and targets. Importing objects from multiple PowerCenter repositories into a single Data Validation Option repository can become hard to manage if care is not taken to only bring in (and only refresh) specific folders from the associated repositories.