1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

What is the diffrence between Multiload & Fastload interms
of Performance?

Question Posted / yuvaevergreen

Answer Posted / yuvaevergreen

For a given empty SET table and input file with same no of
rows, FLOAD is faster than MLOAD.
FLOAD--PHASES--2;MAXIMUM TABLES--1;DML STATEMENTS SUPPORTED-
-INSERT;DDL STATEMENTS SUPPORTED--CREATE,DROP;ERROR TABLES
TO BE DEFINED--YES;WORK TABLES TO BE DEFINED--NO;
MLOAD--PHASES--5;MAXIMUM TABLES--5;DML STATEMENTS SUPPORTED-
-INSERT,DELETE,UPDATE,UPSERT;DDL STATEMENTS SUPPORTED--
DROP;ERROR TABLES TO BE DEFINED--YES;WORK TABLES TO BE
DEFINED--YES;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Steps to create a data model?

650

Explain the most common data types used in teradata?

584

Highlight the advantages of PPI(Partition Primary Index).

557

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1609

Highlight a few of the important components of Teradata?

573




Explain some differences between mpp and smp?

582

Explain the term 'foreign key' related to relational database management system?

546

Explain and compare pros and cons of snow flake schemas?

599

How many sessions of MAX is PE capable of handling at a particular time?

585

How do you create tables? Exact syntax, and create profiles, users in teradata?

547

What are the string manipulation operators and functions associated with teradata?

625

What is meant by a dispatcher?

553

Explain vproc in teradata?

555

Difference between multiload and tpump?

614

What is called partitioned primary index (ppi)?

552