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.