Interested to Buy Any Domain ? << Click Here >> for more details...
Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table
- 6 Answers
- 21152 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / tdguy
In TD14.0, stats can be collected for volatile tables also.
GTTs are stored in temporary space and definition alone is
retained across sessions. Temporary tables are used, when
there is a need to store some aggregate results of rows for
further sql processing. It also increases the need to join
big tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the multi-insert?
What is meant by Teradata Gateway?
In the Primary Index, what is the score of AMPs that are actively involved?
What is the basic syntax for teradata select statement?
How many types of joins are there in teradata?
What are the functions of a teradata dba?
Explain teradata architecture in detail with a diagram.
What are the design features involved in teradata?
What are the different functions performed in development phase?
What is a dimension table?
What do you mean by parsing?
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?
Explain fastload in teradata?
What do you mean by fastexport in teradata?
What happens when a node suffers a downfall?
