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 a sparse index?
How you will check the version of teradata?
Difference between stored procedure and macro?
How can we check the version of Teradata that we are using currently?
Explain how spool space is used.
What are the various reporting tools in the market?
In the Primary Index, what is the score of AMPs that are actively involved?
Highlight the need for Performance Tuning.
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is the primary index in teradata?
What are the various indexes in teradata? How to use them?
How do you set the session mode parameters in bteq?
How can bottlenecks be identified?
What are the available primary index types?
What is inner join and outer join?
