Jim Dettman
jimdettman at earthlink.net
Sun Jun 29 14:03:42 CDT 2003
Susan, Depends on how much tractability you need/want. Typically in a data mart, you don't touch any of the original data including the keys, meaning that you add a new key structure outside of any existing. Also depends a lot on how your DB is structured: natural or surrogate. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Saturday, June 28, 2003 5:27 PM To: AccessD at databaseadvisors.com Subject: [AccessD] AutoNumbers in historical tables When archiving historical data do you change an AutoNumber field to a Number field? Like to hear pros and cons on the subject. Susan H. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com