Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78034 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / ravi bandi
permanent tables:
1.set---which thow out any rows that complete duplicates
2.mutiset--which allows multiple instances for same row.
temporary tables:
1.global temporary tables-- when it is created its
definition stored on data dictionary. the data will be
stored on temp space that's why data is active upto the
session ends, we can collect statistics on GTT.
2.volatile temporary tables--when it is created the
definition is stored on cache.the data will be stored in
spool space,thats why data and table defition both are
active up to session ends.you can't collect statistics on
VTT.
3.derived tables-- when we created the definition is stored
on cache.it is local to an sql query.
they are specified on a query level with an AS keyword in
an sql ststment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are teradata utilities?
What are the different softwares used with their functions in teradata?
Explain the advantages of partitioned primary index in a query?
What are the different table types supported by teradata?
What is meant by Teradata Gateway?
In Teradata, what is the significance of UPSERT command?
What interface is used to connect to windows based applications?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
What is the purpose of indexes?
What is the difference between union and union all in teradata?
Explain teradata vs. Redshift?
Highlight the points of differences between the database and user in Teradata.
What do you mean by teradata intelliflex?
What are the available join types in teradata?
