Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI: SNP Tables related queries: Fetching ODI Metadata Information

Rajneesh S-OracleJul 10 2019 — edited Jul 11 2019

Hi All,

Do you have sql query which will provide below information from SNP tables:

1) List out all mappings/interface and their execution time, start time, end time, total number of records loaded in target, total number of records fetched from sources.

2) List out package names and total execution time for package , start time and end time.

3) List out mapping name, package name, target table name associated in that mapping and source table names in that mapping.

Thanks,

Rajneesh
This post has been answered by Rodrigo Radtke Souza on Jul 10 2019
Jump to Answer
Comments
Post Details
Added on Jul 10 2019
#business-intelligence-applications, #data-integrator, #system-management-and-integration
5 comments
25,452 views