What are the types of tables in Teradata
Answer Posted / terad
Types of Tables in Teradata :
1.Derived
2.Volatile
3.Global Temp.
4.Permanent
4.1. SET
4.2. Multiset
| Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is a sparse index?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is spool space?
What is meant by a Least Cost Plan?
What are the various etl tools in the market?
Can you connect multiload from ab initio?
What is a three-tier data warehouse?
Explain some differences between mpp and smp?
What is node? How many nodes and amps used in your previous project?
What is the difference between global temporary tables and volatile temporary tables?
What is the purpose of using case expression in teradata?
What is the meaning of Caching in Teradata?
What are the things to be considered while creating secondary index?
Explain the types of join supports by teradata?