Interview Questions   Tutorials   Discussions   Programs   

Teradata - What is differences between Fastload and Multiload as per DBA aspect ?




678
views
asked mar September 20, 2014 06:37 AM  

What is differences between Fastload and Multiload as per DBA aspect ?


           

1 Answers



 
answered By vishnoiprem   0  
Fast Load :

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

Multi Load:

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
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert