What are the types of tables in Teradata
- 22 Answers
- 70330 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
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 |
Find 2 highest sal from each dept who have completed 5 year in org
What are aggregate tables? How do you design them using teradata?
what is DYNAMIC SQL in TD?
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
Explain the most common data types used in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
What are the different functions performed in development phase?
What are the newly developed features of Teradata?
Hash collision?
How do you do backup and recovery in teradata?
Name the five phases that come under MultiLoad Utility.
Can we load a Multi set table using MLOAD?
Teradata 
