Archives of the TeradataForum
Message Posted: Wed, 04 Aug 1999 @ 17:26:34 GMT
| 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.
| 
