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
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What are some commonly used bteq scripts?
What is the multi-insert?
What do you mean by fastexport in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What do you mean by parsing?
Highlight the need for Performance Tuning.
How many types of joins are there in teradata?
What is the purpose of joins in teradata?
What are the different functions included in the server software?
List out some of the primary characteristics of teradata.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is meant by a Virtual Disk?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
How do you set the session mode parameters in bteq?
