April 30, 2014 \ Ananth TM Teradata MultiLoad stage Multiload (as source) uses Fast export utility. Multiload (as target) is very efficient when you are doing maintenance activities on multiple large tables. At a time, Multiload stage can perform Inserts/Updates on upto 5 different tables in one pass. Work tables and error tables are created each time you perform an operation using Multiload also. It is automatically dropped once the job has run successfully. However if the job aborts, the work tables have to be manually dropped before the job is run again. Teradata MultiLoad features: • Target table can be populated regardless of it/they is/are empty or not. • Allows inserts, updates, deletes, and upserts • Loads into multiple target tables • Allows non-unique secondary indexes automatically rebuilds them after loading