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 |
Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"
What are the different methods ot loading a dimension table? A fact table etc?
any one answer me how they can analyzing the project using data ware housing?
Explain the types of join supports by teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How do you define Teradata?
I Have Name field in a Table Name ------------- abcde;fgh;ijk; abc;def;jklm;no I want to write a sql to display name field data with out ';'.so i want to replace ; with '' how will write in Teradata
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
Why do you get spool space errors? How do trouble-shoot them?
What interface is used to connect to windows based applications?
How to find duplicates in a table?
How many types of index are present in teradata?