Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78478 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 TPD?
What's the difference between timestamp (0) and timestamp (6)?
What are default access rights in teradata?
How do you verify a complicated sql?
If a Node is busy what are the steps you can take to avoid ?
How many types of joins are there in teradata?
Explain some differences between mpp and smp?
What do you mean by teradata intellicloud?
Differentiate database data and data warehouse data?
What are the different design perspectives used in teradata?
How would you load a very large file in teradata in general?
What are the various indexes in teradata? Why are they preferred?
What do you mean by teradata intelliflex?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the components used in smp and massively parallel processing (mpp) machines?
