Answer Posted / 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 |
Post New Answer View All Answers
Explain the types of join supports by teradata?
What are types of partition primary index (ppi) in teradata?
Syntax for case when statement?
What is partitioned primary index (ppi)?
How do you determine the number of sessions?
What is the use of stored procedures in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the available primary index types in teradata.
What are the functions performed by bynet?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What are the components used in smp and massively parallel processing (mpp) machines?
In BTEQ, how are the session-mode parameters being set?
What is a node in teradata?
What are the steps involved after the disk manager passes the request?
Highlight a few of the advantages that ETL tools have over Teradata.
