Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 20 Aug 2001 @ 16:40:14 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Databases - 1 large or 4 small?
From:   James Judge

Depends on how the slightly different formats migrate to a "single image" schema. By that I mean if you have different indexing (PIs and SIs), cardinality of fact (detail) tables (i.e. will there be data skewing?),etc. You need to do a PDBD gap analysis of current 3 databases to 1. As for the load processes since you currently run three concurrent, assuming you now have 1 table instead of 3 (e.g. a customer table) you cannot run three concurrent loads to the same table. But you could keep 3 load threads and load 1/3 of the tables with each thread. You would have to test for loading elapsed times and balance among the 3 load processes. Being "extremely security conscious" will most likely cause additional overhead of some new added reference table(s). If there is no business reason to combine the images, then why is it being done?

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020