What are the types of tables in Teradata
Answers were Sorted based on User's Feedback
Answer / vinay
As far as i my knoweledge goes we have ,correct me if i am
wrong.
1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
5 VOLATILE TEMPORARY TABLES
These are the five kind of tables.
| Is This Answer Correct ? | 12 Yes | 17 No |
Answer / vinay
as far as i my knoweledge goes we have ,correct me if i am
wrong.
1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
and there is one more i reckon which i cant remember.
| Is This Answer Correct ? | 7 Yes | 25 No |
What is a three-tier data warehouse?
teradata support to automatically increase the character length or not?
What are the enhanced features in teradata v2r5 and v2r6?
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?
what is use of PI(primary index) AND SI(secondary index)
what is amp plz explanation
What are the functions involved in shared information architecture?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
How to run the Teradata jobs in unix environment ???
In general, how do you optimze any sql in teradata?