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 various reporting tools in the market?
What are the components provided on node?
What are the updated features of teradata?
What is meant by a Least Cost Plan?
How is the teradata different from oracle?
What are the 5 phases in a multiload utility?
What is real time and near real time data warehousing?
What is smp and mpp platforms?
Define views in teradata with syntax.
How to Extract data from multiple legacy systems?
What is inner join and outer join?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What is meant by a Parsing Engine?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
