[AccessD] AutoNumbers in historical tables

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




More information about the AccessD mailing list