can we join volatile table with general table an global
temporary table with general table
?
Answer Posted / tdguy
yes. its possible. And in TD 14.0, we can collect stats for
volatile tables also. Therefore queries need to be looked
upon for better performance.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are aggregate tables? How do you design them using teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Write a program to show the parser component used in teradata?
What is meant by Teradata Gateway?
Explain the parallel data extension in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How to identify ppi columns?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is logical data model?
Explain teradata utilities. What is multiload, fast load, tpump?
Is multi insert ansi standard?
What are the different functions performed in development phase?
What is the difference between union and union all in teradata?
List out teradata data types?
What are different table types used in teradata?