Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 08 Apr 2004 @ 12:52:25 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Erwin and Soft RI
From:   McBride, Michael

You can't "specify" soft RI (meaning that RI is taken care of by an application rather than the DBMS). You can only turn hard RI off in ERwin, thereby removing the constraints. Bear in mind, hard RI only works if you are defining Primary Key to Foreign relationships. Since we, at AE, do not user RI at the database level, we don't even bother create PK/FK definitions in the physical models forward engineering process.

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019