Re: Data load ideas

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 04 May 2004 14:31:09 -0600
Message-ID: <BCBD59AD.1455F%tim@sagelogix.com>

They cause harm during EXCHANGE PARTITION operations, which is the issue that started this thread.

They cause no harm if they are "RELY" (i.e. unenforced), allowing the DBA to create ERDs...

on 5/4/04 1:27 PM, Jacques Kilchoer at Jacques.Kilchoer_at_quest.com wrote:

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

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 - 15:28:10 CDT