Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47460 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
Highlight a few of the advantages that ETL tools have over Teradata.
Why managing the data is important?
Explain the term 'columns' related to relational database management system?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Explain BYNET.
How to identify ppi columns?
What is meant by a node?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are normalization, first normal form, second normal form and third normal form?
What is the maximum number of dml can be coded in a multiload script?
What is the use of teradata system software?
What are teradata utilities?
What is the opening step in basic teradata query script?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Can we collect statistics on table level?
