Existing Teradata TPump scripts for upserts do not need to be changed. The following syntax for an upsert will continue to be supported:
DO INSERT FOR MISSING UPDATE ROWS; UPDATE <update-operands>; INSERT <insert-operands>;
Existing Teradata TPump scripts for upserts do not need to be changed. The following syntax for an upsert will continue to be supported:
DO INSERT FOR MISSING UPDATE ROWS; UPDATE <update-operands>; INSERT <insert-operands>;