Re: primary and foregin keys
From: <ak_tiredofspam_at_yahoo.com>
Date: 27 Dec 2004 06:57:52 -0800
Message-ID: <1104159472.359709.42020_at_f14g2000cwb.googlegroups.com>
Date: 27 Dec 2004 06:57:52 -0800
Message-ID: <1104159472.359709.42020_at_f14g2000cwb.googlegroups.com>
I'm a little bit surprised:
>>In an RDBMS, all the current data would be in one table, VIEWs would
provide quarterly summaries and the old data would be moved to the data
warehouse, never purged
...<<
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... Received on Mon Dec 27 2004 - 15:57:52 CET