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
What is teradata? What are some primary characteristics of teradata?
how can we analyze the locks ?
Why teradata is used?
What is difference between user and database in teradata?
What tools would you use for that?
What is teradata?
What is smp and mpp platforms?
What is inner join and outer join?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Why do you get spool space errors? How do trouble-shoot them?
What exactly do you know about catching in teradata?
What are the different functions performed in development phase?
Discuss the advantages of using partitioned primary index in a query?
Explain Teradata performance tuning and optimization?