Re: quick FK question

  • From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
  • To: yong321@xxxxxxxxx
  • Date: Wed, 23 Dec 2009 08:48:14 -0500

Gints,

There's another aspect to this conversation with regards to the fact
that for warehouse implementations foreign key constraints are often
times *enforced* in the ETL process and not in the database
definition.  Insofar as that's the case, the extra expense you
describe in checking that foreign key relationships tie back to a
parent record row isn't incurred.

Rumpi
--
//www.freelists.org/webpage/oracle-l


Other related posts: