When to use MLOAD, FLOAD and TPT connections in informatica?

Question

Can you get some information on when to use MLOAD, FLOAD and TPT connections in informatica.

Thanks for your valuable time.

Answer 1

I have found some points.
MLOAD (MultiLoad):

- Each MultiLoad import task can do multiple data insert, update, and delete functions.
- Each MultiLoad delete task can remove large numbers of rows from a single table.
- Each MultiLoad import task can have up to 100 DML steps; 
- Load data into multiple tables. 
- Works in batch/interactive mode.


FLOAD (Fastload):
- Fastload works only on empty tables(Best for truncate and load strategy).
- Works in batch/interactive mode.

Please add/share your thoughts.

Answer 2

Just addition to the above answer -

Teradata Parallel Transporter (TPT) is a parallel multi-function load environment. Types of system operators in TPT are:
Export – extracts data from Teradata.
Load – loads data into an empty table similar to Teradata Fload utility.
Update – upsert, insert, delete and update operations performed in Teradata tables similar to Teradata Mload utility.
Stream – upsert,insert,delete and update operations in near real-time mode

You cannot access (Macro, Trigger, Joined index, Stored procedures, Hash index, Permanent journal) Teradata objects using TPT.