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
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the components provided on node?
How to select first n records in teradata?
if collect stats but it show low confidence why?
What is the purpose of joins in teradata and what are the available join types?
Can we collect statistics on multiple columns?
What are the steps involved in the process flow of the sql statement through channel attached system?
What can be achieved by using the teradata rdbms?
In general, how do you optimze any sql in teradata?
What are the various reporting tools in the market?
Explain BYNET.
What are the components used in smp and massively parallel processing (mpp) machines?
What are default access rights in teradata?
What is meant by a node?
What are the available primary index types?
