What is the diffrence between Multiload & Fastload interms
of Performance?
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 inner join and outer join?
Describe primary index in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are default access rights in teradata?
What is a dimension table?
Explain the new features of teradata?
What happens when a node suffers a downfall?
how can we analyze the locks ?
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
Define views in teradata with general syntax.
What are the main components of teradata system?
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 uses of client software involved in teradata?
What are different table types used in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?