ERwin Data Modeler: 7.3
There is a link between the Logical model to the Physical model for a Non-Reverse Engineered model. That is as designed. In order to keep column names from changing, you can use the name hardening functionality by taking the following steps:
- Go to the physical side of the model and select Tools | Names | Name Hardening.
- Then check on column in Type Selection, go to Object Selection, and choose either all columns or individual columns.
- In the Action selection, check on the Attributes checkbox under Physical.
- Press Apply, and then Close.
Note: In a Reverse Engineered model, the logical and physical models are not linked. However, in a non-Reverse Engineered model, the physical name is generated by the %AttName macro (by default), that's why when you change the logical attribute name; ERwin will change the corresponding column name in the physical model.