Re: Data load ideas
- From: Tim Gorman <tim@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 04 May 2004 14:31:09 -0600
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@xxxxxxxxx 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
