Archives of the TeradataForum
Message Posted: Thu, 07 Oct 2004 @ 08:21:27 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|