Interested to Buy Any Domain ? << Click Here >> for more details...
How do you eliminate duplicates?
- 3 Answers
- 7943 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
yes...the above option can be used if access has been
provided to create set tables.If not, partition by clause
can be used.
1. create table2 as table1 with no data;
2. insert into table2
sel column1,column2,,,columnn from table1
group by 1,2
qualify row_number() over (partition by
column1,column2,,,columnn order by
column1,column2,,,columnn desc) =1
where table1 is with duplicates and table2 would be target
table.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / 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 |
Answer / tdguy
Adding to the above,if enough spool space is available, 1.
create a volatile table with the same structure 2. insert
into volatile table
sel column1,column2,,,columnn from table1 group by 1,2
qualify row_number() over (partition by
column1,column2,,,columnn order by
column1,column2,,,columnn desc) =1
3. delete from target table and insert from volatile table.
All the above steps should be done with the same session.
| Is This Answer Correct ? | 2 Yes | 0 No |
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 ?
If the table does not have duplicates then which utility you can suggest to load the data ?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
In Teradata, how do we Generate Sequence?
If the script is aborted. why it is aborted and how can you identify ?
Differentiate primary key and partition key?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
if collect stats but it show low confidence why?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
Explain the parallel data extension in teradata?
How do you see a ddl for an existing table?
Explain the most common data types used in teradata?
Teradata 
