How do you create a table with an existing structure of another table with data and with no data?
Answer / praveen kota
Create table tablename as existing tablename with (no) data
| Is This Answer Correct ? | 0 Yes | 0 No |
How to select first n records in teradata?
how can i answer for question like teradat architecture in interveiw
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
i have column like below studentid studentname sub1 sub2 sub3 1 aaa 40 70 90 2 bbb 60 80 50 i want to execute every student highest mark in which subject my o/p like below studentid studentname sub3 sub2 1 aaa 90 2 bbb 80
What is the use of virtual processor connectivity in teradata?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
How you will check the version of teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Aborted in Phase 2 data acquistion completed in fastload?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
Explain about Skew Factor?
Did you write stored procedures in teradata?