Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ODI metadata query to get the source tables and the joins between them

Received Response

1

Views

1

Comments

Pushpesh Pallav

Pushpesh Pallav Rank 1 - Community Starter

May 11, 2016 7:09AM in Oracle Business Intelligence Applications

Hi There,

We need to have a query which gives us the source tables populating the target table.

Like all the EBS source tables which populates the Fact table W_AP_INV_DIST_F and the joins between them.

Tanks in advance.

Pushpesh Pallav

0

Answers

Thomas Dodds Rank 8 - Analytics & AI Strategist

May 12, 2016 8:21AM

Implement the data lineage that comes with OBIA ...

0