Removing relationships while preserving generated attributes in SQL Developer Data Modeler
Hi,
We need to remove some relationships between entities in our logical model in Oracle SQL Developer Data Modeler. However, we would like to keep the attributes that were originally generated as a result of those relationships (for example, migrated attributes/foreign key attributes).
Is there a specific feature or recommended procedure that allows us to delete a relationship without automatically removing the associated generated attributes from the entities?
We understand that migrated attributes are owned by the relationship and that one possible workaround is to manually create equivalent non-migrated attributes in the child entity before deleting the relationship. However, we would like to know whether there is any alternative or built-in method to achieve this, especially in cases where a large number of relationships and migrated attributes are involved.