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.