What are the types of tables in Teradata
Answer Posted / maruthi
create insert drop delete
sys sys sys sys-------------derived table
user user sys sys-------------volatile table
user user user sys--------------global temp table
user user user user-------------normal table
-->derived table will be created by system while executing sub queries
-->global temp table & volatile table has to be created by user by mentioning "global temporary table" , "volatile table" respectively in the syntax at the time of creating the table.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the primary index in teradata?
Explain the most common data types used in teradata?
What are the different table types supported by teradata?
Which is more efficient group by or distinct to find duplicates?
What is the purpose of joins in teradata and what are the available join types?
What do you mean by parsing?
What type of indexing mechanism do we need to use for a typical data warehouse?
Explain fallback in teradata?
Explain fastload in teradata?
What are the functions performed by bynet?
How to select first n records in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is a sparse index?
Difference between stored procedure and macro?