What is the diffrence between Multiload & Fastload interms
of Performance?
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
In Teradata, how do we Generate Sequence?
What is the opening step in basic teradata query script?
Explain amp in teradata?
Explain fallback in teradata?
How to run a query in teradata?
What is meant by a Least Cost Plan?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
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?
What is the difference between fastload and multiload? Which one is faster?
Comment whether bottleneck is an error or not.
How will you solve the problem that occurs during update?
What is the use of stored procedures in teradata?
How do you set the session mode parameters in bteq?
Why teradata is used?
What is the meaning of Caching in Teradata?