top button
Flag Notify
Site Registration

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

+1 vote
2,409 views

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

Thanks for your valuable time.

posted Nov 10, 2014 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

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 Nov 11, 2014 by Shweta Singh
0 votes

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.

answer Nov 13, 2014 by Shatark Bajpai
Similar Questions
+1 vote

The command to convert from .xlsx to csv works in putty, but the same when given in informatica fails....I am getting exit error code 32512.

The workflowlog >>

Severity    Timestamp   Node    Thread  Message Code    Message
INFO    9/8/2016 5:28:20 PM Node_BIDEV  140284941813504 LM_36621    Command task instance [Convert_csv]: started command [convert], with pid [14121] on node [Node_BIDEV].
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36623    Command task instance [Convert_csv]: execution of command [convert] did not complete successfully with exit code [32512]
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36626    Command task instance [Convert_csv]: previous command [convert] failed and "run if previous command succeeded" option is set, the remaining commands will not be run.
ERROR   9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36320    Command task instance [Convert_csv]: Execution failed.
WARNING 9/8/2016 5:28:21 PM Node_BIDEV  140285390595840 LM_36373    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is suspended.
INFO    9/8/2016 5:28:22 PM Node_BIDEV  140285390595840 LM_36375    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Sent suspension email to email user 
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36371    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles] is aborting.
WARNING 9/8/2016 5:28:27 PM Node_BIDEV  140284973283072 LM_36322    Workflow [wf_CUSTOMER_SURVEY_CORE_DailyFiles]: Execution aborted.

The command script I am using is

libreoffice --headless --convert-to csv:"Text - txt - csv (StarCalc)":"126,0,76,1,2" /var/opt/load/Sourcedata/CUSTOMER_SURVEY/2016Q2_ML_V1.xlsx

Please help me...

...