Hello, Does anyone have a solution for the following design problem:
We have five data sources of customer information that feed into an order system. A business requirement has arisen to create a common customer profile that would somehow tie the disparate datasources back to the common customer profile. Our data architect has suggested creating a table that has a unique sequence primary key and columns for each of the 5 data sources that would be the foreign keys back to the customer information in the 5 data sources. If a 6th data source was created (which is highly possible), we would need to alter this "common" table and add a sixth column Is that a good approach? Something just doesn't feel right to me and I am wondering if any of you have experienced this problem before. Your thoughts would be appreciated. Thanks, Jim M. __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
