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

Question

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

Gianni Ceresa · Answer

Hi @Wasif ,

This kind of question is in the wrong place…

You maybe have some integration with analytics features in your OTM product, but the Oracle Analytics products do not own such integration and aren't in charge of it. You should ask that kind of question in a place covering OTM, because OTM is not an Oracle Analytics product.

RVohra · Answer

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

This is because:

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