Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 77728 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / ravi
We know that in Teradata all the tables are either SET or MULTISET.
The difference between SET and MULTISET tables is –
SET tables – SET tables did not allow duplicate values in the table.
MULTISET tables – MULTISET tables allow duplicate values in table.
Many of us already defined the temporary tables and permanent table .
Type of Temporary Table :
1) Global temporary Table : GTT can be either SET or Multiset .
2) Volatile Table : It can be either SET or Multiset .
3) Derived Table : they are specified on a query level with an AS keyword in
an sql ststment.
Permanent Table : Permanent Table DDL as well as data stored in Permanent Space . It can be either Set or Multiset .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Difference between stored procedure and macro?
In the Primary Index, what is the score of AMPs that are actively involved?
Explain the term 'database' related to relational database management system?
What is the purpose of upsert command?
What is the command in bteq to check for session settings ?
Mention a few of the ETL tools that come under Teradata.
What are the updated features of teradata?
What is meant by a Channel Driver?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
In general, how do you optimze any sql in teradata?
Different phases of multiload?
Describe the between keyword in teradata?
Explain teradata vs. Redshift?
