You refresh a source repository when the contents of the PowerCenter repository have changed. You usually refresh a target repository only when there are additions or changes to connection objects.
When you refresh a repository, Data Validation Option imports the source, target, folder, and connection metadata from the PowerCenter repository. Therefore, Data Validation Option objects that use changed or deleted PowerCenter objects might no longer be valid after you refresh a repository. If you created table pairs, single tables, or tests with tables that were deleted from the PowerCenter repository, Data Validation Option deletes them when you refresh the repository.
To refresh all repositories at once, right-click
in the Navigator, and select
Refresh All Repositories
. To refresh one repository, right-click the repository, and select
When you refresh one repository, you can select the objects to refresh. Select one of the following options:
Data Validation Option reimports all source, target, folder, and connection metadata. It updates the folder list, and the Sources and Targets folders in the Navigator.
Data Validation Option reimports connection metadata. Select this option when a PowerCenter user adds, removes, or updates connection objects.
Data Validation Option reimports folder metadata. It updates the folder list in the Navigator. Select this option when a PowerCenter user adds or removes folders.
Folders (Sources and Targets)
Data Validation Option reimports source and target metadata. It refreshes the contents of the
folders in each folder in the repository. Select this option when a PowerCenter user adds, removes, or modifies sources or targets in folders. If the PowerCenter folder contains a shortcut to an object in another folder, you must to refresh the other folder also.
You can also refresh repository folders individually. You might refresh a folder after you refresh the folder list and Data Validation Option imports a new folder. To refresh a repository folder, right-click the folder in the Navigator, and select
Refresh Folder (Sources and Targets)
. Data Validation Option refreshes the contents of the
folders within the folder you refresh.
Refreshing everything in a repository or refreshing all repositories can take several minutes to several hours, depending on the size of the repositories. If you work with a small number of repository folders, you can shorten refresh time by refreshing the folders individually.