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
List out teradata data types?
What is teradata?
How many sessions of MAX is PE capable of handling at a particular time?
What are the available join types in teradata?
How to select first n records in teradata?
What do you mean by teradata intelliflex?
What are differences between teradata and ansi session modes in teradata?
Explain teradata architecture in detail with a diagram.
Highlight all the modes that are present under Confidence Level.
How can you track login parameters of users in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
Explain parsing engine in teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?
What are teradata utilities?
