Archives of the TeradataForum

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

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

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>>