What is the use of upsert command in teradata?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the between keyword in teradata?

812


What is bteq script in teradata?

820


What do you mean by ttu in teradata?

739


What does sleep function does in fast load?

829


Explain some differences between mpp and smp?

809


Why teradata is used?

769


In general, how do you optimze any sql in teradata?

766


Explain the term 'foreign key' related to relational database management system?

744


What are the steps involved in the process flow of the sql statement through channel attached system?

857


Why are oltp database designs not generally a good idea for a data warehouse?

817


How do you verify a complicated sql?

827


Explain amp in teradata?

755


What is the purpose of joins in teradata and what are the available join types?

762


Explain the types of join supports by teradata?

766


What are different table types used in teradata?

783