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
Why teradata is used?
List the logical and conditional operators that are used with teradata along with their meanings?
How is MLOAD Teradata Server restarted after execution?
What are the different softwares used with their functions in teradata?
How can you track login parameters of users in teradata?
What are the different design perspectives used in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What is the purpose of joins in teradata?
How many tables can you join in v2r5?
How you will check the version of teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What is meant by a Least Cost Plan?
What do you mean by teradata intelliflex?
What is multi insert?
Explain and compare pros and cons of snow flake schemas?