Looking for instruction on physicalizing of a data model

View previous topic View next topic Go down

Looking for instruction on physicalizing of a data model

Post  juliasuzuki on Wed Sep 04, 2013 11:25 am

Hello,

Does anyone has a documentation or instruction on how to denormalize a logical data model into a physical data model in Erwin?
I remember collapsing multiple tables into one table in physical in ERwin, but can't recall the steps or the functionality of ERwin that I used before.
Since I didn't remember, I jumped into views and denormalized tables but know I am skipping one step between logical data model and view.

Thank you
Julia Suzuki

juliasuzuki

Posts : 2
Join date : 2013-08-29

View user profile

Back to top Go down

Re: Looking for instruction on physicalizing of a data model

Post  BoxesAndLines on Thu Sep 05, 2013 9:12 am

There is a property at the entity and attribute level called "Logical Only". This will remove the entity/attribute from the physical model. Likewise, there is a property at the table and column level called "Physical Only" which will remove the table/column from the Logical model. Using those settings you can accurately maintain a logical and physical model.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum