Before you create a PowerCenter resource, you must configure the metadata source. If you do not correctly configure the metadata source, the metadata load can fail or the metadata can be incorrectly loaded in the Metadata Manager warehouse.
To configure PowerCenter, complete the following tasks:
Configure permissions.
Check in versioned repository objects.
If the PowerCenter repository is on an IBM DB2 for LUW database, configure the database heap size.
If the PowerCenter repository is on an Oracle 11.1 database, disable extended statistics.