Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79311 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
VOLATILE TABLES - Occupies spool space - Data/Definition
dropped when the session ends or user drops it.
DERIVED TABLES - Occupies spool space - Data dropped as
soon as the query ends.
GLOBAL TEMPORARY TABLES - Occupies temporary space - Data
dropped as soon as the user deletes or session ends -
Definition stored permanently in the DD.
SET/MULTISET TABLES - Occupies permanent space -
Data/Definition retained until user deletes it.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the steps involved in the process flow of the sql statement through channel attached system?
What are the available primary index types?
When tpump is used instead of multiload?
Explain teradata utilities?
How is MLOAD Client System restarted after execution?
What are the design features involved in teradata?
Explain and compare pros and cons of snow flake schemas?
How will you solve the problem that occurs during update?
What is teradata?
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 ?
Explain some differences between mpp and smp?
Difference between star and snowflake schemas?
What is a three-tier data warehouse?
What is upsert statement in teradata?
What is the purpose of using case expression in teradata?
