Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47479 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
What is logical data model?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is real time and near real time data warehousing?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Describe the between keyword in teradata?
Name the five phases that come under MultiLoad Utility.
What are the components provided on node?
Describe primary index in teradata. And what are the available primary index types?
Explain and compare pros and cons of start schemas?
What do you mean by fastexport in teradata?
Highlight the differences between Primary Key and Primary Index.
What are the steps to create a data model?
Is multi insert ansi standard?
Define views in teradata with general syntax.
Explain parsing engine in teradata?
