Interested to Buy Any Domain ? << Click Here >> for more details...
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 many types of joins are there in teradata?
How to run a query in teradata?
What are the commands to make a new table, change a table and remove a table in teradata?
Why does varchar occupy 2 extra bytes?
What do you mean by teradata sql assistant?
What is the purpose of indexes?
What are teradata utilities?
Different phases of multiload?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How many sessions of MAX is PE capable of handling at a particular time?
What interface is used to connect to windows based applications?
Can we collect statistics on table level?
What are the different functions performed in development phase?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
what are the uses of fact table and dimension table in banking project?
