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

Explain the meaning of Amp?

0 Answers  


What are the 5 phases in a multiload utility?

0 Answers  


How do you eliminate duplicates?

3 Answers  


How do you do backup and recovery in teradata?

0 Answers  


What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,






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

4 Answers   TCS,


What happens in a conflict? How do you handle that?

0 Answers  


can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,


why use references rather than pointers in the public api, particularly for arguments which are modified?

0 Answers  


What are the functions involved in shared information architecture?

0 Answers  


What do you mean by fastexport in teradata?

0 Answers  


What is database exceptions in teradata?

0 Answers  


Categories