Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47837 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
Name the five phases that come under MultiLoad Utility.
What do you mean by ttu in teradata?
What is oltp?
Did you write stored procedures in teradata?
What is the function of parser component in teradata?
If RDBMS is halted what will you do ?
How do you define Teradata?
Can we collect statistics on multiple columns?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
How many tables can you join in v2r5?
What is called partitioned primary index (ppi)?
What is meant by a node?
What are the available primary index types?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What are the various indexes in teradata?
