Monday, October 1, 2012

PC86 - Purge older versions of objects in a versioned PowerCenter Repository

pmrep connect -r Repo_Name -d Domain_Name -n Administrator -x Pwd> test.out

pmrep purgeversion -n -f > test1.out

last_n_versions_to_keep --- Number of latest checked-in object versions to keep for an active object in the folder specified (note: -f is an optional feature).

The value must be an integer greater than 0.

For example, enter 5 to purge all versions except the last five checked-in versions.

1 comment:

  1. Join stage is used to join the data from two tables. With datastage etl tool we can join with integrated queries

    Datastage Tutorial