Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between Multiload & Fastload interms
of Performance?
- 8 Answers
- 47836 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
Describe primary index in teradata. And what are the available primary index types?
What are the string manipulation operators and functions associated with teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What type of indexing mechanism do we need to use for a typical data warehouse?
How to run a query in teradata?
Explain the teradata primary index mechanics in detail with a diagram.
How to eliminate product joins in a teradata sql query?
What are the functions of a teradata dba?
What are some commonly used bteq scripts?
What is the purpose of upsert command?
What is smp and mpp platforms?
Explain the term 'database' related to relational database management system?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the purpose of indexes?
Describe primary index in teradata?
