Re: primary and foregin keys

>> 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 - 22:37:24 CET