What are the types of tables in Teradata
Answer Posted / rd
1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
What are the joins in teradata?
Explain teradata utilities?
What is bteq script in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Differentiate primary key and partition key?
How is MLOAD Client System restarted after execution?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
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?
Explain and compare pros and cons of snow flake schemas?
What are some commonly used bteq scripts?
Highlight a few of the important components of Teradata?
Which is faster fastload or multiload?
What does sleep function does in fast load?
What is the purpose of upsert command?