Interview Questions   Tutorials   Discussions   Programs   

Teradata - Why MLOAD needs Work Tables?

asked mar September 20, 2014 06:38 AM  

Why MLOAD needs Work Tables?


1 Answers

answered By vishnoiprem   0  
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
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!