Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79309 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 purpose of joins in teradata?
Explain how spool space is used.
What do you mean by fastexport in teradata?
Highlight the advantages of PPI(Partition Primary Index).
What are the string manipulation operators and functions associated with teradata?
When tpump is used instead of multiload?
How do you create tables? Exact syntax, and create profiles, users in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is meant by a Virtual Disk?
What is the purpose of joins in teradata and what are the available join types?
Explain PDE.
What are some primary characteristics of teradata?
How to view every column and the columns contained in indexes in teradata?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Which is more efficient group by or distinct to find duplicates?
