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 are the advantages of teradata?
What are the steps involved after the disk manager passes the request?
Explain the new features of teradata?
Discuss the advantages of using partitioned primary index in a query?
What are the things to be considered while creating secondary index?
How is the teradata different from oracle?
How is MLOAD Client System restarted after execution?
Explain the advantages of partitioned primary index in a query?
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
In Teradata, what is the significance of UPSERT command?
Explain the term 'row' related to relational database management system?
What is teradata and why it is used?
What's the difference between timestamp (0) and timestamp (6)?
Explain some differences between mpp and smp?
What is meant by a Channel Driver?
