What is the use of upsert command in teradata?



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

Post New Answer

More Teradata Interview Questions

how many modules are there in telecome domain?how to explain the architecture?

0 Answers  


what is the query for retrieve the unique values(not display the duplicates values) from single table?

6 Answers   IBM,


What is SQL Assistence?please eample

4 Answers   IBM,


What are the various indexes in teradata? Why are they preferred?

0 Answers  


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

0 Answers   Infosys, Wells Fargo,






Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.

13 Answers  


How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?

2 Answers  


What is logical data model?

0 Answers  


where we can use the delimiter in mload? pls let me know

2 Answers   Wipro,


What is the difference between teradata and basic rdbms?

0 Answers  


What are the available primary index types in teradata.

0 Answers  


I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,


Categories