What are the types of tables in Teradata
Answer Posted / kishore
Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Why is the case expression used in teradata?
What is stored procedure in teradata?
What can be achieved by using the teradata rdbms?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What do you mean by teradata intelliflex?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
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?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the available primary index types in teradata.
Explain teradata utilities. What is multiload, fast load, tpump?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How to identify ppi columns?