Archives of the TeradataForum

Message Posted: Thu, 07 Oct 2004 @ 08:21:27 GMT

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

Hi,

We are using Informatica ETL to load a Teradata Box. The architecture demands rows to be upserted into the database. Obviously we have two approaches viz. Relational Update Else Insert or MLOAD upsert.

We know that upsert loader is very fast and are satisfied with it. Our concern is the amount of resources a loader consumes versus a sequence of relational statements. Can anyone put light on same.

Thanks,

Sid

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