I have a model that has special character, like '&' sign in the Logical side. However, when I switch from Logical to Physical side, the special characters change to underscores (_) for Tables and Columns. I want to keep the special characters; how to do that?
In erwin DM, to retain a special character, click on Actions | Model Naming Options and under Physical Tab check the checkbox for 'Allow Special DBMS characters'. Also make sure Name Mapping Tab has Special Characters set to ‘Leave’ (default). That will keep the special characters in the Physical side as well when switching from Logical to Physical side.