1 of 1 people found this helpful
MetaQuery is a tool that can be used to query against PowerCenter repository for some of the key properties in sessions, workflows, mappings, transformations, and permission objects.
So, please download this tool and you don't have to write any queries. Please refer the following article On MetaQuery. You can find the download location also in the same document.
Some of the supported properties in Metquery include :
1. SQL Override in SQ
2. SQL Override in Lookup
3. Source Table
4. Target Table
5. Owner Name for source
1. Source File delimiter
2. Target File delimiter
3. SQ SQL override
4. Lookup SQL override
5. SQLs from SQL Transformations
This matches your exact requirements.
Her is a list of all of the other relational source related repository views besides REP_ALL_SOURCES
This view provides all the fields and field properties for all sources defined in REP_ALL_SOURCES View.
This view provides a list of relational database table sources that have been analyzed through the Source Analyzer tool or imported from DDL
This view provides access to the fields in relational sources. Use the source name to retrieve all the fields belonging to the source.
The OWNER_NAME is not available via the MX views. As Syed mentioned, use MetaQuery tool. There is an option to get the owner name for a source in the category "Mappings".