Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Aug 1999 @ 17:26:34 GMT


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


Subj:   Re: Referential Integrity Use
 
From:   John HR Schuster

I have worked at a number of Teradata sites and I can confirm that none of them are using RI. Ri will slow down the loading of data from your source systems. Most RI problems can be discovered and repaired using a set of special SQL scripts to check RI. I have used these just after new data is loaded to check for mismatched codes, missing values. etc.

If I fix the RI problems using RI within Teradata I'll never find out where the problems are in the source data stream. I want to know where these problems are so I can go back and have them fixed or cleaned prior to loads. Using RI in a DW is like taking an antacid for continuous stomach aches just to discover you have a problem with spicy food. The problem is the spicy food not the stomach ache.



     
  <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