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

What are the primary characteristics of the Teradata.

0 Answers  


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

0 Answers  


hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?

1 Answers  


Can we Suggest as how is the process to get a job in teradata in current market??Is it easier???

1 Answers   IBM,


What are the multiload utility limitations?

0 Answers  






How many sessions of MAX is PE capable of handling at a particular time?

0 Answers  


Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,


What are the functions of a Parser?

0 Answers  


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

0 Answers  


what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,


What do you mean by tpt in teradata?

0 Answers  


We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,


Categories