Archives of the TeradataForum
Message Posted: Wed, 26 Sep 2012 @ 14:57:09 GMT
< -- Anonymously Posted: Wednesday, September 26, 2012 05:22 -- >
We have SCD1 dimension which we load from source file every day.
Could you please help me understand which factors to consider for selecting between delete/load or mload with do insert for missing update rows?
We are receiving around one million rows every day. We have 10% update records and less than 1% inserts. Which one is better in such scenario?
Would like to understand how mload do insert for missing update rows works internally.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|