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

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

teradata support to automatically increase the character length or not?

What are the components provided on node?

Describe primary index in teradata?

During the Display time, how is the sequence generated by Teradata?

Explain and compare pros and cons of snow flake schemas?

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

What is database exceptions in teradata?

what is DYNAMIC SQL in TD?

How to find duplicates in a table?

For more Teradata Interview Questions Click Here