What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 45799 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
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 spool space? Why do you get spool space errors? How do trouble-shoot them?
What is meant by a Highest Cost Plan?
How do you determine the number of sessions?
How will you solve the problem that occurs during update?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How many sessions of MAX is PE capable of handling at a particular time?
What is the meaning of Caching in Teradata?
Describe the between keyword in teradata?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
what are the day to day activities of teradata DBA ?
What is a node in teradata?
Highlight a few of the important components of Teradata?
any one answer me how they can analyzing the project using data ware housing?
Explain teradata architecture in detail with a diagram.
How can we check the version of Teradata that we are using currently?
