Why MLOAD needs Work Tables?

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.