ANSI Merge option V2 R13

General

ANSI Merge option V2 R13

Currently we are using TPUMP utility for bulk loading. I heard that ANSI merge fea­ture in Teradata Database 12 provides useful method for actively loading and transforming data.

My question here is can we make use of ANSI merge in place of TPUMP. Before that does it apply Exclusive lock on target table before it dumps bulk data?

Appreciate further discussions on this subject.
2 REPLIES
Enthusiast

Re: ANSI Merge option V2 R13

The MERGE INTO statement (ANSI merge) applies a write lock on the target table.
Enthusiast

Re: ANSI Merge option V2 R13

Take a look at the TPump manuals for restrictions on the types of statements you can use. Since TPump isn't exactly a bulk loader, you might be able to use ANSI Merge. But you really don't need to. TPump has it's own capability to do an UPSERT. See the manual for "DO INSERT FOR MISSING UPDATE ROWS".