What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 45800 Views
- Cap Gemini, Intel, I also Faced
- E-Mail Answers
Answer Posted / chinna
Compare to FastLoad Multiload is slower But loads into
Multiple Tables with different DML Operations.Multiload
suports maximum 20 DML Operations.multiload slowdown
operation of AMP.There is no Trasand Journal
Overhead.Multiload Maximum 15 Multiload scripts run at a
time.Multiload supports duplicates also
FastLOad loads data into empty tables.it loads only one
table at a time.compare to all utiities it is faster.it
can't load the duplicates(either multiset NUPI).it loads
the error data into error tables.fastload fastload does
insert operation between Begin and endloading statements.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Explain the meaning of Amp?
Why is the case expression used in teradata?
How to view every column and the columns contained in indexes in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Why are oltp database designs not generally a good idea for a data warehouse?
Explain some differences between mpp and smp?
Why teradata is used?
What are the various reporting tools in the market?
Highlight the need for Performance Tuning.
Explain the term 'tables' related to relational database management system?
What are the available join types in teradata?
Explain the term 'foreign key' related to relational database management system?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
In Teradata, what is the significance of UPSERT command?
What is called partitioned primary index (ppi)?
