Archives of the TeradataForum
Message Posted: Mon, 20 Aug 2001 @ 12:14:52 GMT
We are in the process of re-designing our Teradata databases and I have some questions.
First, some background.
Lookup and other shared tables are loaded into only one database, the others refer to these tables. Currently the loads run concurrently for all three companies, after the shared tables have been loaded.
Currently 90% of all queries are run against Company A, but users of Company B data will increase dramatically after the re-design. There are some users who require data from all companies; the majority of users require data from only 1 company at a time.
The size of the data for Company A is greatest, with Company B catching up quickly. Company C & D are small.
The query tool on the new database/s will be Microstrategy 7.
What will the impact on loading and performance be if all the companies are loaded into 1 database? What advantages/disadvantages are there to making one database or 4?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|