PowerCenter Repository Maintenance

Back Next

Purging Versions of Objects

You can purge specific versions of objects, or you can purge all versions of objects.

To permanently remove an object version from the repository, you must purge it. You need to check in object versions to purge them. You might want to purge a version if you no longer need it and you want to reduce the size of the repository database.

You can purge multiple versions of an object from the repository at the same time. To completely purge an object from the repository, you must purge all versions. If you purge a version that is not the latest version, the repository keeps a record of the purge in the object history. If you purge the latest version, the repository does not keep a record of the purge.

You use the Repository Manager to purge versions. When you purge versions of objects, you can perform the following tasks:

Purge individual object versions.
You can select object versions in the View History window or Query Results window to purge the individual object versions.

Purge versions based on criteria.
You can purge versions at the repository, folder, or object level based on purge criteria. This type of purge is called an advanced purge. Use advanced purges to purge deleted or active objects. For deleted objects, you can specify the objects to purge based on the date of deletion. For active objects, you specify the versions to purge based on the version number, the check-in date, or both.

Preview purge results.
Preview an advanced purge to view the purge results before you purge objects from the repository. You can view summary or detailed information about the purge.

Purge composite objects.
You can purge versions of composite objects, and you can purge versions of dependent objects that make up composite objects. View object dependencies before you purge composite objects. You might get unexpected results if you do not determine the dependent object versions that a purge affects.

The following table shows the Repository Manager commands that you can use to purge versions at the object, folder, or repository level:

Purge Type	Single Object Version	Multiple Object Versions	Versions at Folder Level	Versions at Repository Level
By Object Version (View History Window)	yes	yes	no	no
By Object Version (Query Results Window)	yes	yes	no	no
Based on Criteria (Navigator)	yes	yes	yes	yes
Based on Criteria (View History Window)	yes	yes	no	no
Based on Criteria (Query Results window)	yes	yes	no	no

Rename Saved Search

Table of Contents

PowerCenter Repository Maintenance

PowerCenter Repository Maintenance

Purging Versions of Objects

Purging Versions of Objects