Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data load ideas
Please ignore my last e-mail.=20
-----Original Message-----
Jacques Kilchoer
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.=3D20
-----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
=3D3D ENFORCED to prevent MV "staleness". Otherwise, there is no =3D
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.
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Tue May 04 2004 - 14:28:24 CDT
-----------------------------------------------------------------