Archives of the TeradataForum
Message Posted: Wed, 04 Aug 1999 @ 16:34:38 GMT
| Subj: || || Re: Referential Integrity Use |
| From: || || John K. Wight |
I have never used RI (recent to TD) in a data warehouse environment where Teradata 'lives'. One main reason is that in an environment
like this, I want to know what doesn't match and if I enforce RI, I will never get the parent/child violations that I want to know about.
In an OLTP world RI is important to enforce - however, I have sourced a lot of data from DB2, Oracle, etc. (where RI was supposed to be
enforced) in the my life of TD Data Warehousing and have found (to my customer's amazement) RI violations in the warehouse. I use a simple
SQL shell at the points of interest that will report violations and this has always allowed the customer to go back and 'fix' the OLTP
data/RI constraints. Don't know if this helps? Bill Inmon also advocates not using RI in a warehouse for the same reasons I mentioned
I guess a good question is, wouldn't you want to know where your OLTP data is 'broken'? It can and does exist!
John K. Wight
Senior Solutions Consultant - Retail Solutions Group