RE: Data load ideas

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 4 May 2004 12:27:38 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F877F8@irvmbxw02>

Would the FKs in a data warehouse do any harm? I imagine that they would come in handy for your new DBA to do an entity relationship diagram.=20

-----Original Message-----

Tim Gorman

Why are you using foreign keys in a data warehouse anyway?

The only technical reason for FKs in a DW is when one is trying to use materialized view query-rewrite and one is utilizing QUERY_REWRITE_INTEGRITY
=3D ENFORCED to prevent MV "staleness". Otherwise, there is no = technical
reason for FKs, as there is no need for RI to be enforced in the DW, because
the DW is not the source-of-record for the data. Validation reporting is
much more effective than enforced constraints.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Tue May 04 2004 - 14:25:04 CDT