Transforming to physical with ERwin

From the logical data model of the Atomic Warehouse Model (AWM) or the Dimensional Warehouse Model (DWM), you can create a physical data model.

1. Import the Glossary.
   1. Right click on Naming Standards and select New.
   2. Right click on the new item and select Properties.
   3. Check the Is Active radio button on the editor and select Match Whole Words Only and then Import From CSV.
   4. Close the dialogue.
2. Change the ERwin Model Naming Options.
   1. Go to Tools > Model Naming Options.
   2. In the General tab, select Use file: and browse to select the NamingGlossary.nsm.
   3. In the Logical tab, change the maximum length for Relationships to 128.
   4. In the Name Mapping tab, select the Use Glossary check box for Entity to table, Domains and Attribute to Column.
   5. In the Macro Name cell for Entity to table, enter %upper(%EntityName()).
   6. In the Macro Name cell for Relationships, enter FK_%RelId.
   7. For Special Characters choose Replace in the drop-down list.
   8. Replace with _ (underscore) character.
      
   9. On the Duplicate Names tab, select Automatically rename Duplicate Names.
   10. Click OK to close the dialog box.
3. Create the physical model.
   1. Go to Action > Design Layer > Derive New Model.
   2. In the Target Model section select the Physical radio button.
   3. In the Target Model tab, select Physical and specify the correct database and version.
   4. Click Next.
      Note: If a new screen pops up for Type Resolution, just click Finish to go back to the Derive Model wizard.
   5. In the Object Selection tab, select the relevant subject areas.
   6. Click Derive to create a model in ERwin.
   7. Save as an .Erwin file. For example, AWM_Physical.Erwin.