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 type of indexing mechanism do we need to use for a typical data warehouse?
If RDBMS is halted what will you do ?
Why are oltp database designs not generally a good idea for a data warehouse?
how many modules are there in telecome domain?how to explain the architecture?
How many sessions of MAX is PE capable of handling at a particular time?
What are the scenarios in which full table scans occurs?
What is the purpose of indexes?
Write a program to show the parser component used in teradata?
What is stored procedure in teradata?
What do you mean by teradata sql assistant?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What is meant by a Least Cost Plan?
Explain teradata utilities?
Explain the new features of teradata?
How to Extract data from multiple legacy systems?
