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
What is basic teradata query language?
Explain the types of join supports by teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Highlight the advantages of PPI(Partition Primary Index).
What is smp and mpp platforms?
How you will check the version of teradata?
Define views in teradata with general syntax.
Why are oltp database designs not generally a good idea for a data warehouse?
What is teradata? Also, list out some of the primary characteristics of teradata.
What is meant by Teradata Gateway?
Can we collect statistics on multiple columns?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What tools would you use for that?
What are the available primary index types in teradata.