Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2007 @ 17:57:28 GMT

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

I have a general question about Multiload Upsert Performance.

We are considering utilizing Multiload Upserts for the load strategy into many tables in a new subject area of the data warehouse.

We only consider this due to a reduction in complexity for Audits and Control processes. Basically to cheat on the development time up front In order to shorten our time to production.

My reservation is performance degradation over time as the tables grow (some will grow rapidly, 100's of thousands of records per day).

The file from the source system would be many million rows Mixture up updates and inserts, Primarily Updates.

My question has anyone experienced significant detrimental performance impacts, after utilizing this type of load strategy.

Any opinions , lessons learned, or friendly advice would be a great help in the decision of whether or not to implement this load strategy for Large, rapidly growing tables.

Regards,

Eric W. Barner
Senior Teradata DBA
HCA Information Technology & Services

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