Archives of the TeradataForum
Message Posted: Tue, 04 May 2004 @ 11:48:33 GMT
<-- Anonymously Posted: Tuesday, May 04, 2004 06:28 -->
We have 3 divisions lets say for discussion purposes A,B and C.
B is the Core of the Warehouse since 4 years and now A wants to join in. Should we aim for a single Database to store all the Tables or should we have separate Databases for each division.
If we have a single Database, there is a hell of an effort to Allign A to B and also to change B (small as B is the base) to have commonality with A. Then there is Testing on data for multiple divisions to see the Data Integration Issues.
If we have separate databases and the have physical integration with Union views across the databases, there is less effort and less testing. There will also be a big Join effort when using these views. But it will be a nightmare to manage multiple databases and there is wastage in provisioning of space for multiple databases.
If C also takes the Database for itself approach, we will be killing the EDW.
We have a EDW. Insights required on the following:
Is it normal to have separate databases to store data for different divisions/subject areas.
What would you suggest.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|