Looking for instruction on physicalizing of a data model
2 posters
Page 1 of 1
Looking for instruction on physicalizing of a data model
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
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
Re: Looking for instruction on physicalizing of a data model
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.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
![-](https://2img.net/i/empty.gif)
» Tracking of historical data using SCD2 in a non-dimensional data model
» data model architecture for economic forecast data
» Canonical Data Model for Data warehouse
» Model Data
» Data Model
» data model architecture for economic forecast data
» Canonical Data Model for Data warehouse
» Model Data
» Data Model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|