Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / lilian
Work Tables are used to receive and sort
data and SQL on each AMP prior to storing them permanently
to disk.
The purpose of worktables is to hold two things:
1. The Data Manipulation Language (DML) tasks
2. The input data that is ready to APPLY to the AMPs
MultiLoad will automatically create one worktable for each
target table. This means that in IMPORT
mode you could have one or more worktables. In the DELETE
mode, you will only have one worktable since that
mode only works on one target table.
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain the term 'primary key' related to relational database management system?
What are the various etl tools in the market?
How does hashing happens in teradata?
What are the different functions performed in development phase?
What do you mean by teradata intelliflex?
What is the difference between union and union all in teradata?
what is object level locking ? where do appear this type of locking ?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What are the functions of a teradata dba?
What is the purpose of indexes?
What is TPD?
How to select first n records in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
List out all forms of LOCKS that are available in Teradata.
