dbTalk Databases Forums  

ERwin - logical and physical model problem

comp.databases.oracle.marketplace comp.databases.oracle.marketplace


Discuss ERwin - logical and physical model problem in the comp.databases.oracle.marketplace forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
smiley81
 
Posts: n/a

Default ERwin - logical and physical model problem - 09-04-2003 , 03:32 PM







I was wondering if there was a way to create 2 physical models from 1
logical model - the first physical would have a star schema and the
second physical would be a normal relational layout.



Both physical models will have the same fields as themselves and the
logical model; however the 2 physical models will have 2 different
layouts (star schema and relational).



The point is to not have to update the metadata of the physical
databases individually. I would only like to change the metadata in the
logical model which could then be carried over to the physical models.



Is this possible to do with one logical model?



Thanx


--
Posted via http://dbforums.com

Reply With Quote
  #2  
Old   
Daniel Morgan
 
Posts: n/a

Default Re: ERwin - logical and physical model problem - 09-05-2003 , 08:24 PM






smiley81 wrote:

Quote:
I was wondering if there was a way to create 2 physical models from 1
logical model - the first physical would have a star schema and the
second physical would be a normal relational layout.

snipped




Create the logical model. Then make a copy of the ERwin file with a
different name.

BTW: ERwin, just like Oracle has version numbers. And there are
significant differences between versions that affect answers.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.