Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 04 Aug 1999 @ 16:34:38 GMT

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

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 above.

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
NCR Corp.

  <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: 28 Jun 2020