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 uses of bynets in multi-node systems?
Differentiate primary key and partition key?
What are the joins in teradata?
In Teradata, what is the significance of UPSERT command?
Describe the between keyword in teradata?
How can you track login parameters of users in teradata?
Highlight the differences between Primary Key and Primary Index.
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain fallback in teradata?
What is a sparse index?
What is teradata and why it is used?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are the different table types supported by teradata?
What is the use of virtual processor connectivity in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
