Work Tables are used to receive and sort data and SQL on each AMP prior to storing them permanent on 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 Multi Load 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.
When you loading data it's not load directly to amp,first it load to work load at the 5 stage it loads from work table to target table,Then after final stage it's delete the work tables and error tables every thing