Archives of the TeradataForum

Message Posted: Wed, 06 Feb 2008 @ 12:48:48 GMT

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

Omer - is it possible to use a common file to load multiple tables? MLoad supports this capability.

Consider Multiset, but if U cannot take the pain of duplicates/bad-feeds then U must live with the overhead of SET processing. Perhaps tighter front-end processing may prevent the loading of the wrong files.

Are U only loading new data and updates? Are U completely reloading every table during each run?

U need to consider what is being done that does not have to be done.

- read data once

- exactly one process updates one or more tables

Finally, a 1 node 7 amp box is awfully small for a production box. Consider scaling back to 2-3 simultaneous job streams.

Best of Luck.

Rgrds,

Bill Gregg

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