Answer Posted / guest
Let us consider table ‘B’ containing duplicates.
Create a empty table ‘A’ with set option and send the data
from table ‘B’ to table ‘A ‘so that only unique records will
be inserted. Now drop table ’B’ and rename table ‘A’ with
table ‘B’.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Difference between stored procedure and macro?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What are aggregate tables? How do you design them using teradata?
Explain the term 'tables' related to relational database management system?
What is the use of virtual processor connectivity in teradata?
What are the design features involved in teradata?
Explain some differences between mpp and smp?
How many types of joins are there in teradata?
List out teradata data types?
In Teradata, how do we Generate Sequence?
What do you mean by parsing?
What is TPD?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?