how to delete duplicate records in multi set table without using any tables
- 2 Answers
- 13129 Views
- Accenture, Nest, South Nests Software Solution, Spiro Solutions, I also Faced
- E-Mail Answers
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
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the uses of client software involved in teradata?
What is the purpose of joins in teradata and what are the available join types?
What is the meaning of Caching in Teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
What are the frequently used data types in teradata?
How to identify ppi columns?
What are the multiload utility limitations?
How to Extract data from multiple legacy systems?
What is dimensional modeling?
What is a sparse index?
What is teradata? What are some primary characteristics of teradata?
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 modules are there in telecome domain?how to explain the architecture?
What tools would you use for that?
