PowerCenter repository metadata is a wealth of information that is highly valuable for PowerCenter Administrators and Developers. This metadata can be accessed using the MX views or the REP_ tables provided in the repository. This information is useful for many activities, i.e. QA, Optimization, taking proactive measures etc.Attached SQL scripts contains the repository queries that can be used to fetch the metadata of your PowerCenter Mappings such as:

• List of all transformations used by the Mappings (grouped by folders).
• List of all the Mappings using a particular transformation.
• List of Mappings and users who saved the Mapping last.
• List all the Mappings that use certain objects (of your interest).
• Details of Mappings using, the date and string functions in the Expression transformation.
• And much more?

These queries have been prepared for the Oracle database. You can change these queries to suit your Repository Database.You may also like to download other similar solutions:

• Repository Reports for PowerCenter Workflows
• Repository Reports for PowerCenter Sessions
• PowerCenter Repository Object Validation Reports