Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: primary and foregin keys

Re: primary and foregin keys

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 27 Dec 2004 13:37:24 -0800
Message-ID: <1104183444.683038.150890@f14g2000cwb.googlegroups.com>


>> in many shops data gets loaded into the DW frequently (such as
monthly), but is still kept in the OLTP for a year or two. Then the data is just purged from OLTP... <<

WalMart purges their OLTP pretty fast (90 days or whatever the return policy is), but keeps 16 months in the Data Warehouse. The OLTP is not really involved with the quarterly reporting, just operational data at the store level.

I guess everyuone is different ... Received on Mon Dec 27 2004 - 15:37:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US