Logical Table Details in Data Lineage

Suraj Shenoy K S

The FDI data lineage document currently does not have Logical Layer information. Providing Logic Table details will help in identifying the Dimension Logical Tables which can be used to join with custom facts. Please consider providing this at earliest as it helps the developers to build custom logical stars.

Nupur Joshi-Oracle

Hi @Suraj Shenoy K S - In FDI documentation refer data lineage section - https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-data-lineage.html#GUID-455C2845-B374-4A3E-8FA5-5A310D437BEE this has details of presentation object and corresponding physical tables and attribute. Similar details would be available for all pillars in similar sections for each pillar.

Please let us know if this does not meet your ask. We can look into solving the issue that you may be facing.

Regards,

Nupur

Suraj Shenoy K S

Thank you for your response Nupur. I was specifically looking for Logical Table details, since that is what will be required when we create custom logical stars and would want to re-use OOTB logical dimension tables. Right now we are having to guess the name of the Logical Dim since it is not available in the documentation.

Krishna Prasad Kotti-Oracle

Hi @Suraj Shenoy K S Can you elaborate why we need logical table details ?

If you are looking for details of the logical star is arranged, then you can use the below documentation for the information to get information about Relationship Diagram
https://docs.oracle.com/en/cloud/saas/analytics/24r3/fahia/chapter-relationship-diagram.html#GUID-331D5F7D-B928-4056-9252-9BAE97B95C0D

Suraj Shenoy K S

Thank you for checking on this @Krishna Prasad Kotti-Oracle. We need the logical table details of OOTB dimensions so that we can use those to join with custom fact tables in custom logical stars, thereby increasing the extensibility of FAW without having to recreate OOTB dimensions in custom schema again.

Also I had looked at the document you referenced above, but it has only physical star details and not the logical start details.