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 the use of having index on table?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
how can we analyze the locks ?
List out teradata data types?
What is bteq script in teradata?
Explain and compare pros and cons of start schemas?
Explain some differences between mpp and smp?
Explain fastload in teradata?
What is logical data model?
What is a dimension table?
How do you define Teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
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
How do you do backup and recovery in teradata?
Did you write stored procedures in teradata?
