Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Aug 1999 @ 15:26:19 GMT


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


Subj:   Referential Integrity Use
 
From:   Dale Leake

I am new to the List Server and just interested in user's usage of the fairly new RI Constraints within the Teradata RDBMS.

According to NCR folks working at our site, we are being told that no one (yes, I said no one) is currently using RI constraints in a production environment on Teradata. Can this be true?

We are migrating from an Oracle Decision Support System (DSS) database where we depend upon RI to help manage data integrity because our host data may not always be 'clean'. We are used to the problems that may occur because of RI and manage it within Oracle. Unfortunately we now need to turn to application level RI on Teradata so that we can utilize the Fastload/Multiload utilities without permanent RI in place on the primary tables.

I'm interested in any comments from persons currently using or considering RI in production. Also, any input regarding gotchas on application level RI within Teradata.


Thanks in advance for any input.



     
  <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: 27 Dec 2016