What is the diffrence between Multiload & Fastload interms
of Performance?
Answer Posted / kumar
Multiload can at max 5 tables with non unique secondary
indexes on them. where as in fastload u cannot have
secondary indexes on the table.
In multiload you can insert,update or delete data in
already populated tables whereas in fastload the target
table should be empty.
Multiload works in 5 phases whereas fastload works in two
phases.
If we want to load data into an empty table then fastload
is best option as compared to multiload.
| Is This Answer Correct ? | 54 Yes | 6 No |
Post New Answer View All Answers
What are normalization, first normal form, second normal form and third normal form?
Different phases of multiload?
Explain the term 'row' related to relational database management system?
what is object level locking ? where do appear this type of locking ?
How can you track login parameters of users in teradata?
What is the function of parser component in teradata?
What are the functions performed by bynet?
What are teradata utilities?
What is bteq utility 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
Differentiate primary key and partition key?
What do you mean by fastexport in teradata?
What is primary index and secondary index?
Steps to create a data model?
Define views in teradata with general syntax.