upsert

Prior to the availability of the Teradata connector , the TDMLoad stage was mainly recommended and used for supporting the database update and upsert operations .

在Teradata连接器可用之前，主要推荐使用TDMLoad工作台来支持数据库更新和更新插入操作。

Merge also replaces the client-side logic known as upsert that performs conditional updates and inserts .

Merge还替换了执行条件更新与插入客户端逻辑upsert。

The upsert iterator is the one that performs the actual updates or inserts and deletes .

迭代器upsert执行实际的更新或者插入及删除操作。

It does not support the update , upsert , or sparse-lookup operations .

它不支持更新、更改插入或稀疏查找操作。

Update driver & uses the Multiload protocol and supports parallel insert / update / delete / upsert operations to new or existing tables .

更新驱动程序&使用Multiload协议并支持对新表或已有表执行并行插入/更新/删除/更新插入操作。

Both the matched and non-matched rows are fed into the upsert iterator .

匹配与未匹配行都被送入upsert迭代器中。

Then the upsert iterator updates the rows that have joined and inserts the rows that are null extended into target table based on insert clause specification .

然后，upsert迭代器将更新已经连接的行，并基于insert子句规范将空扩展行插入到目标表中。