What are the types of tables in Teradata
- 22 Answers
- 70122 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
Permenant Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET table - Allows Duplicate Values.
Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.
I dont have idea about Derived Table, could someone
elaborate on this?
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
How to Extract data from multiple legacy systems?
What is meant by a Channel Driver?
Explain the advantages of partitioned primary index in a query?
What is upsert statement in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the basic syntax for teradata select statement?
What is teradata?
Why managing the data is important?
What is the use of teradata system software?
What is the difference between fastload and multiload?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What are some commonly used bteq scripts?
What is spool space?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is collect statistics?
