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
What is collect statistics?
What is meant by a Least Cost Plan?
What is the difference between fastload and multiload?
Explain parsing engine in teradata?
What is the purpose of joins in teradata and what are the available join types?
Explain the term 'tables' related to relational database management system?
How do you verify a complicated sql?
Explain and compare pros and cons of snow flake schemas?
In general, how do you optimze any sql in teradata?
What is a clique?
What is the purpose of upsert command?
What are the frequently used data types in teradata?
Explain some differences between mpp and smp?
What do you mean by teradata intelliflex?
What is a three-tier data warehouse?
