What is the use of upsert command in teradata?

Question Posted / shashank shukla

What is the use of upsert command in teradata?..

Answer / praveen kota

It is a update or insert. If the updating row exists in target table, it will update else it will insert the data

Is This Answer Correct ?

0 Yes

0 No

More Teradata Interview Questions

Difference between multiload and tpump?

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

Explain teradata vs. Redshift?

What exactly do you know about catching in teradata?

I want to write one query How to get Matched records and unmatched records in table?

Difference between stored procedure and macro?

Does SDLC changes when you use Teradata instead of Oracle?

Explain about Skew Factor?

What do you mean by ttu in teradata?

What is basic teradata query language?

what is identity columns in teradata

What are the frequently used data types in teradata?

For more Teradata Interview Questions Click Here