What is the use of upsert command in teradata?
- 1 Answers
- 1135 Views
- I also Faced
- E-Mail Answers
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 |
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What are the functions of a Parser?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is meant by a node?
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What are the joins in teradata and how many types of joins are there in teradata?
How to copy teradata scripts from ur remote desktop to server machine?
What are the various indexes in teradata?
How to relege locks in fastload and multiload? example?
When tpump is used instead of multiload?
can we join volatile table with general table an global temporary table with general table ?
Teradata 
