In ArcGIS Pro, using an enterprise geodatabase:
What are the options for dynamically joining from a FC to a related query?
Any comments or other options?
Oracle 18c 10.7.1 EGDB.
You have listed several options for dynamically joining from a feature class to a related query in an enterprise geodatabase using ArcGIS Pro:
You also mentioned that for options 1-4 above, the fields from the source feature class are editable while the fields in the join table are not editable.
Some other options you could consider include:
Creating a relationship class in the geodatabase. This allows you to define the relationship between two tables and can be used to create a dynamic join between the feature class and the related table. The fields from the related table will be shown in the attribute table and can be edited as per the relationship class settings.
Using the 'Join Field' tool. This tool can be used to join two tables based on a common field and the fields from the joined table will be shown in the attribute table and can be edited as per the join settings.
Using the 'Relate' tool. This tool can be used to establish a relationship between two layers in a map and the fields from the related table will be shown in the attribute table and can be edited as per the relate settings.
All these options are dependent on your specific use case, the database management system you are using and your organization's policies and standards.
In your case, you are using Oracle 18c 10.7.1 Enterprise Geodatabase, so you may want to check the documentation and best practices provided by Oracle and Esri on how to work with joins in an enterprise geodatabase.
Thanks @JMalik.