Archives of the TeradataForum
Message Posted: Wed, 06 Feb 2008 @ 12:48:48 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|