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 |
how many modules are there in telecome domain?how to explain the architecture?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
What is SQL Assistence?please eample
What are the various indexes in teradata? Why are they preferred?
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.
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
What is logical data model?
where we can use the delimiter in mload? pls let me know
What is the difference between teradata and basic rdbms?
What are the available primary index types in teradata.
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.