Main use: to load empty tables at high speed. The target tables must be empty in order to use FastLoad Supports inserts only - it is not possible to perform updates or deletes in FastLoad Although Fastload uses multiple sessions to load the data, only one target table can be processed at a time Teradata Fastload does not support join indexes, foreign key references in target tables and tables with secondary index defined. It is necessary to drop any of the constraints listed before loading and recreate them afterwards. The maximum number of concurrent Teradata Fastload tasks can be adjusted by a system administrator. Fastload runs in two operating modes: Interactive and Batch Duplicate rows will not be loaded
Main use: Load, update and delete large tables in Teradata in a bulk mode Efficient in loading very large tables Multiple tables can be loaded at a time. Updates data in a database in a block mode (one physical write can update multiple rows) Uses table-level locks Resource consumption: loading at the highest possible throughput Duplicate rows allowed
DBA want to check the table structure regarding load..
In Fload case table structure should have set table and index should be UPI so that it should not check every row and load data very fast
In Mload case table structure should have any table and any index