What are the types of tables in Teradata
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 difference between fastload and multiload? Which one is faster?
Difference between multiload and tpump?
What do high confidence, low confidence and no confidence mean in explain plan?
List out some of the primary characteristics of teradata.
What are differences between teradata and ansi session modes in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the different design perspectives used in teradata?
How does hashing happens in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
Why teradata is used?
What are the uses of client software involved in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Highlight the differences between Primary Key and Primary Index.
Difference between star and snowflake schemas?
What are tpump utility limitations?