Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
List of physical joins in the RPD
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):
Answers
-
-
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);
0 -
-
Thank you Subhakara. It worked like a charm!
0