HDOWNER database is oracle analytics and GLOGOWNER database, how data flow between them

Wasif

In otm we have Database GLOGOWNER and have Data Dict, from where we know what is in tables, and analytics have HDOWNER database
and data in otm has flows to analytics
but dont know in between mapping
means shipment related tables in GLOGOWNER we know how this data is flows to which folders of subject area in HDOWNER dont know
like: Packaged_Item_GID is necessary for workbook (which has shipment related data, but packaged_item_gid is not in shipment analysis folder

RVohra

There is no 1-to-1 table mapping between these schemas.
This is because:

1. Data is extracted, transformed, and loaded (ETL) via Oracle’s OTM Analytics ETL / ODI mappings.
2. The HDOWNER schema is a star-schema warehouse, so data is denormalized and reorganized.
3. Subject Areas in OAC (Shipment, Order, Freight, etc.) use presentation-layer metadata, not raw tables.
4. You might need to dig in deeper to find the mapping.