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


Please Help Members By Posting Answers For Below Questions

What are aggregate tables? How do you design them using teradata?

735


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

766


Write a program to show the parser component used in teradata?

640


What is meant by Teradata Gateway?

666


Explain the parallel data extension in teradata?

736






What is teradata? Also, list out some of the primary characteristics of teradata.

667


How to identify ppi columns?

741


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1406


What is logical data model?

751


Explain teradata utilities. What is multiload, fast load, tpump?

659


Is multi insert ansi standard?

1847


What are the different functions performed in development phase?

699


What is the difference between union and union all in teradata?

716


List out teradata data types?

638


What are different table types used in teradata?

661