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


Please Help Members By Posting Answers For Below Questions

What are the different softwares used with their functions in teradata?

550


What is meant by a Clique?

560


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1871


Explain teradata architecture?

606


What are normalization, first normal form, second normal form and third normal form?

603






What is the purpose of indexes?

567


What tools would you use for that?

543


How to eliminate product joins in a teradata sql query?

579


What is the purpose of joins in teradata and what are the available join types?

521


What are the components used in smp and massively parallel processing (mpp) machines?

568


Is multi insert ansi standard?

1720


How can you track login parameters of users in teradata?

604


What exactly do you know about catching in teradata?

607


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

2324


How to select first n records in teradata?

589