Which teradata utility support Upsert logic from oracle to Teradata ?

Tools

Which teradata utility support Upsert logic from oracle to Teradata ?

Hi All,

I have a scenerio of loading data from source oracle to teradata target.
I need to implement Upsert logic to load from oracle to Teradata.

But I have heard that BTEQ does not support Upsert Logic.

MLOAD support upsert logic but not for tables as source, but for external files as source.

Please let me know as which utility supports upsert logic for my scenerio.

Thanks in advance..

1 REPLY
Enthusiast

Re: Which teradata utility support Upsert logic from oracle to Teradata ?

BTEQ (and all the Teradata client APIs, such as ODBC) support a limited form of upsert (single row, no FROM table or subquery allowed).

A limited form of the MERGE statement (from ANSI SQL:2003) was implemented in Teradata V2R6.2. This provides an upsert capability using a query expression as source, with the restriction that the query must return a single row.

Teradata 12.0, which is approaching beta, supports enhanced capabilities for the MERGE statement, eliminating the single-row restriction on the source query.