What are the types of tables in Teradata
Answer Posted / terad
Types of Tables in Teradata :
1.Derived
2.Volatile
3.Global Temp.
4.Permanent
4.1. SET
4.2. Multiset
Is This Answer Correct ? | 61 Yes | 1 No |
Post New Answer View All Answers
What are the different functions performed in development phase?
What is collect statistics?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain teradata vs. Redshift?
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?
Can we collect statistics on table level?
Explain the term 'primary key' related to relational database management system?
What is the meaning of Caching in Teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
how can we analyze the locks ?
What's the difference between timestamp (0) and timestamp (6)?
What are the different softwares used with their functions in teradata?
What is the basic syntax for teradata select statement?
Name the five phases that come under MultiLoad Utility.
What is the purpose of joins in teradata and what are the available join types?