|
Archives of the TeradataForumMessage Posted: Thu, 28 Feb 2013 @ 10:01:28 GMT
Sughesh, Merge in Teradata is good alternative to Upsert since it does block update and it also designed to update and insert in a single step. Moreover it requires only single table read to does its operation. But make sure you are aware of changes with V2R5 and V12 MERGE rules & Limitations. Thanks John
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||