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 |
what are the day to day activities of teradata DBA ?
Can we load a Multi set table using MLOAD?
In Teradata, what is the significance of UPSERT command?
Explain and compare pros and cons of start schemas?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
If RDBMS is halted what will you do ?
How many codd's rules are satisfied by teradata database?
What's the difference between timestamp (0) and timestamp (6)?
What are the various etl tools in the market?
1)WHAT IS THE EXACT DIFFERENCE BETWEEN TERADATA AND ORACLE? 2)MOST OF THE COMPANIES ARE USING TARA DATA FOR "DWH PROJECTS" ONLY? WHY?
6 Answers Bank Of America, Wipro,
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.