List of physical joins in the RPD

Sahithi Kolasani-Oracle

Content:

Is there a way we can get the list of all physical joins defined in the OAC RPD? Repository documentation tool is giving lineage from physical layer till presentation layer. But join conditions are missing. Any way of getting entire list of physical joins?

Version (include the version you are using, if applicable):

OAC BI Administrator tool

Code Snippet (add any code snippets that support your topic, if applicable):

Amrita Gupta-Oracle

Hi Sahithi,

From the Joins manager, you can view all the physical joins - like below. However, if you are looking to export and document, not sure if that's feasible.

Sahithi Kolasani-Oracle

Hi Amrita,

Yeah, looking for the export of these joins into a csv or xls file. As of now, when we copy and paste, it comes like below which is not the format we are looking for.

-DECLARE FOREIGN KEY "Data Warehouse".."ADW"."Fact_W_SITE_PROTCL_DEVTNS_F"."Fact_W_RXI_SITE_PROTCL_DEVTNS_F_Foreign Key#7" AS "Fact_W_SITE_PROTCL_DEVTNS_F_Foreign Key#7" HAVING

(  "Data Warehouse".."ADW"."Fact_W_SITE_PROTCL_DEVTNS_F"."COMPANY_TGT_WID" ) REFERENCES "Data Warehouse".."ADW"."Dim_W_COMPANY_TGT_D"."Dim_W_COMPANY_TGT_D_Key"

PRIVILEGES ( READ);

Subhakara Netala-Oracle

Hi Sahithi,

From Repository query, select Type as Physical Foreign and click on query. You can see all joins also from column we can select required columns from the list. Finally it can be saved into CSV file. Check will this suffice your requirement.

Sahithi Kolasani-Oracle

Thank you Subhakara. It worked like a charm!