Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the function of parser component in teradata?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is a three-tier data warehouse?
What is primary index and secondary index?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the various indexes in teradata? How to use them?
During the Display time, how is the sequence generated by Teradata?
In Teradata, how do we Generate Sequence?
Explain fastload in teradata?
What is the multi-insert?
What are the various etl tools in the market?
What are the joins in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Can we collect statistics on table level?
