how to delete duplicate records in multi set table without using any tables
Answer Posted / nidhi
make use of Qualify, though it wont delete duplicate..but
also wont show u duplicate as well in answer set.
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Mention a few of the ETL tools that come under Teradata.
What are the primary characteristics of the Teradata.
Explain amp in teradata?
What are the functions of a Parser?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Describe primary index in teradata?
What is the basic syntax for teradata select statement?
What are the available primary index types?
Explain teradata architecture?
What are aggregate tables? How do you design them using teradata?
Highlight all the modes that are present under Confidence Level.
What are the different functions performed in development phase?
Explain the term 'database' related to relational database management system?
In general, how do you optimze any sql in teradata?