Interested to Buy Any Domain ? << Click Here >> for more details...
can we join volatile table with general table an global
temporary table with general table
?
- 4 Answers
- 9978 Views
- IBM, I also Faced
- E-Mail Answers
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
Comment whether bottleneck is an error or not.
What is node? How many nodes and amps used in your previous project?
What is the maximum number of dml can be coded in a multiload script?
In BTEQ, how are the session-mode parameters being set?
Explain BYNET.
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What do you mean by ttu in teradata?
What is meant by a dispatcher?
What is multi insert?
What are the uses of bynets in multi-node systems?
Highlight a few of the advantages that ETL tools have over Teradata.
What is the difference between global temporary tables and volatile temporary tables?
What are teradata utilities?
Explain the most common data types used in teradata?
How do you see a ddl for an existing table?
